Where are dialog sheets stored in excel 2007 vba?

By Dillon.damien ·
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

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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums