Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 5 Dialog Sheets (Excel 2000 SR1)

    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

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 5 Dialog Sheets (Excel 2000 SR1)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •