Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming popup forms
I am trying to create a macro that opens a popup form.
The popup form has a series of check boxes (10-15). When the popup form closes (or maybe when the user clicks an "OK" button), I want to the macro to select a cell on the current row and a defined column and for every check box that's selected, insert some text in the cells starting with the selected cell and, in the same column, on the rows below, advancing one row for each additional selected check box. Does that make sense? E.g. Say the cursor is in A25 and four check boxes were ticked (item 1, item 7, item 8 and item 13). The defined column is J. On closing the popup form Cell J25 would contain Item1, J26: Item 7, J27: item 8 and J28: item 13. Any ideas? Regards, Richard. -- Regards. Richard. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming popup forms
Sounds like a userform. Take a look at
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- HTH RP (remove nothere from the email address if mailing direct) "Richard Sherratt" wrote in message ... I am trying to create a macro that opens a popup form. The popup form has a series of check boxes (10-15). When the popup form closes (or maybe when the user clicks an "OK" button), I want to the macro to select a cell on the current row and a defined column and for every check box that's selected, insert some text in the cells starting with the selected cell and, in the same column, on the rows below, advancing one row for each additional selected check box. Does that make sense? E.g. Say the cursor is in A25 and four check boxes were ticked (item 1, item 7, item 8 and item 13). The defined column is J. On closing the popup form Cell J25 would contain Item1, J26: Item 7, J27: item 8 and J28: item 13. Any ideas? Regards, Richard. -- Regards. Richard. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming popup forms
On Tue, 6 Dec 2005 08:45:01 -0000, "Bob Phillips"
wrote: Sounds like a userform. Take a look at <snip Thanks, Bob. Great stuff. -- Regards. Richard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RefEdits and normal forms / forms in a DLL | Excel Programming | |||
Forms that open from forms | Excel Programming | |||
Calling Forms from Forms - Exit problems | Excel Programming | |||
Are you sure popup box | Excel Programming | |||
Forms Toolbar Programming | Excel Programming |