Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form triggered by selection change
Hi!
Am a bit of a usrform/ vba newbie so dont even know if im in the right forum, but here goes anyway. The problem I have is this: Would like for a userform to pop-up when the selection january!F4 is changed. The userform will ask user to fill in the dates for that years holidays. Depending whether its a half-day or whole day, the entries should populate Info!A1 and Info!B1 respectively. The userform would only used once a year. Grateful for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form triggered by selection change
You would use the change event for Sheet January
Right click on the sheet tab of January and select view code Put in code like Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$F$4" then userform1.show End if End Sub Now you need to construct Userform1 to take the actions you describe. http://www.visualbasicforum.com/show...409#post594409 http://support.microsoft.com/?id=168067 XL97: WE1163: "Visual Basic Examples for Controlling UserForms" Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms 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/kb/244761/en-us XL2000: How to Use ADO to Return Data to a ListBox or ComboBox 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 -- Regards, Tom Ogilvy "littleme" wrote in message oups.com... Hi! Am a bit of a usrform/ vba newbie so dont even know if im in the right forum, but here goes anyway. The problem I have is this: Would like for a userform to pop-up when the selection january!F4 is changed. The userform will ask user to fill in the dates for that years holidays. Depending whether its a half-day or whole day, the entries should populate Info!A1 and Info!B1 respectively. The userform would only used once a year. Grateful for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Accessing selection list within a user form | Excel Programming | |||
user Form change | Excel Programming | |||
User Form Change | Excel Programming | |||
Which User Form Listbox selection just checked? | Excel Programming |