I have a piece of code which creates and formats a graph based on user input into two text boxes. The instructions are in French and I want to translate them to English.
I have changed the text on the buttons using the properties box but I cannot find where to change the text on the dialog box.
The code which calls the dialog box is as follows:
Private Sub CommandButton1_Click()
Dim var As String
CommandButton3_Click
0
var_ok = DialogSheets(“Boite1”).Show
var_date = Date
With DialogSheets(1)
var_periodes = .EditBoxes(“texte1”).Text
var_lignes = .EditBoxes(“texte2”).Text
End With
…
I cannot find where the dialogsheet is defined. Is there a certain place that this could be stored? Is it possible that something is hidden or has been tranformed into a user form for excel 2007?