M
MJP
Apologies if this is really stupid question...
In Excel 95 my forms were via Dialog sheets and setting the name of labels
via VBA was easily achieved by :
DialogSheets("Dialog1").label(x).text = lab_txtname
where x represented the label number and lab_txname the name I wanted the
label to have(at run time the data on the sheet determines the label names
for dynamic form creation)
However, now I have moved to Excel 97, dialog sheets have become User forms,
but I've tried the same syntax as above, but with UserForm1, rather than
Dialog1, but it isn't working.
Can anyone tell me how to set the label texts via VBA?
Thanks in advance,
Mitch
In Excel 95 my forms were via Dialog sheets and setting the name of labels
via VBA was easily achieved by :
DialogSheets("Dialog1").label(x).text = lab_txtname
where x represented the label number and lab_txname the name I wanted the
label to have(at run time the data on the sheet determines the label names
for dynamic form creation)
However, now I have moved to Excel 97, dialog sheets have become User forms,
but I've tried the same syntax as above, but with UserForm1, rather than
Dialog1, but it isn't working.
Can anyone tell me how to set the label texts via VBA?
Thanks in advance,
Mitch