Question

Locked

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
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?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums