Excel 5 Dialog Sheets (Excel 2000 SR1)

Topic

New Reply

I am creating a dialog box for a client report. I’m using a “old” dialog sheet instead of a VBA user form because the UI has a lot of drop down lists that the client wants to be able to edit themselves later and I thought it would be easier for them to edit a “List” sheet rather than having them edit a Macro.

My problem now is that I don’t know how to get text entered into the text boxes in the dialog box, back into the spreadsheet.

Can anyone help me with that?

Thanks in advance,

Christa

Reply | Quote

Replies

Sheets(“Sheet1”).Range(“G3”).Value = DialogSheets(“Dialog1”).EditBoxes(“Edit Box 4”).Text

Reply | Quote