Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel 5.0 Dialog - What is this?
I'm not sure of it's purpose but I'll tell you what I'd like to do with it.
I'd like to open a workbook and have one of these pop up as a form that I create. I'd like the data entered into this form to collect in the rows and columns of a related 'Sheet', sequentially. I have no idea how to program Excel. Is it possible to do this? Is there a popular third party application designed to do this. I need help - has anyone done this before? Thank you for the help. This is something I've been curious about for some time. Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel 5.0 Dialog - What is this?
You might want to start at this site. It pretty much walks you through the
basics of using Visual Basic for Applications, which sort of debuted with Excel 5.0. http://www.excel-vba.com/excel-vba-contents.htm "Powlaz" wrote: I'm not sure of it's purpose but I'll tell you what I'd like to do with it. I'd like to open a workbook and have one of these pop up as a form that I create. I'd like the data entered into this form to collect in the rows and columns of a related 'Sheet', sequentially. I have no idea how to program Excel. Is it possible to do this? Is there a popular third party application designed to do this. I need help - has anyone done this before? Thank you for the help. This is something I've been curious about for some time. Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel 5.0 Dialog - What is this?
Matt,
Dialog sheets are the <old way of doing this. Unless you have a good reason to use them, look into using a userForm instead. These should get you started: http://www.j-walk.com/ss/excel/tips/userformtips.htm http://contextures.com/xlUserForm01.html NickHK "Powlaz" wrote in message ... I'm not sure of it's purpose but I'll tell you what I'd like to do with it. I'd like to open a workbook and have one of these pop up as a form that I create. I'd like the data entered into this form to collect in the rows and columns of a related 'Sheet', sequentially. I have no idea how to program Excel. Is it possible to do this? Is there a popular third party application designed to do this. I need help - has anyone done this before? Thank you for the help. This is something I've been curious about for some time. Matt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel 5.0 Dialog - What is this?
Also, don't forget about Data=Form . . .
Put you headers in starting in A1 of the Activesheet going across row1 for example A1: Name B1: Address C1: City D1: State E1: ZipCode then select A1 and do Data=Form. . . -- Regards, Tom Ogilvy "Powlaz" wrote in message ... I'm not sure of it's purpose but I'll tell you what I'd like to do with it. I'd like to open a workbook and have one of these pop up as a form that I create. I'd like the data entered into this form to collect in the rows and columns of a related 'Sheet', sequentially. I have no idea how to program Excel. Is it possible to do this? Is there a popular third party application designed to do this. I need help - has anyone done this before? Thank you for the help. This is something I've been curious about for some time. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use MS Excel 5.0 Dialog | Excel Worksheet Functions | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
control of dialog macro dialog box. on open | Excel Programming |