Custom Dialog box

crimlet · May 3rd, 2002, 03:28 AM

I have a book that gives the commands
Insert / Macro / Dialog, for V5
which is supposed to enable the editing of a custom dialog box, already containing the OK and cancel buttons. You are then supposed to be able to add other items like drop down boxes, edit boxed ect...

does anyone know how to do this in XL97

Nibbles · May 3rd, 2002, 03:34 AM

Hi,

Sounds like you're talking about userforms. Go to 'Creating Userforms' in the Excel VBA help, or there's an excellent example to get you going on the front page of MrExcel.com, at the very bottom of the screen under 'VBA Macros - Examples', first one in the list.

Hope this helps,

Nibbs

crimlet · May 3rd, 2002, 03:42 AM

perfect thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 03:28 AM	#1
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	I have a book that gives the commands Insert / Macro / Dialog, for V5 which is supposed to enable the editing of a custom dialog box, already containing the OK and cancel buttons. You are then supposed to be able to add other items like drop down boxes, edit boxed ect... does anyone know how to do this in XL97

May 3rd, 2002, 03:34 AM	#2
Nibbles Board Regular Join Date: Apr 2002 Location: Surrey, United Kingdom Posts: 75	Hi, Sounds like you're talking about userforms. Go to 'Creating Userforms' in the Excel VBA help, or there's an excellent example to get you going on the front page of MrExcel.com, at the very bottom of the screen under 'VBA Macros - Examples', first one in the list. Hope this helps, Nibbs

May 3rd, 2002, 03:42 AM	#3
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	perfect thanks