Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open an input screen
please help
i have a list of names each with a button next to it and when pressed i would like to open a form with their name in it. also in this form i would like a drop down list with FDA 1, OTDR 1, FDA 2, INTERIM, FDA 3, OTDR 2, FDA 4, SUMMARY. next to this is it possible to have a date picker so to make it easier for the inputter. now when they press ok i want the date placing below the relevant item for instance: if they chose fda 3 and date 15-mar-06 and pressed ok. cell g5 is the space for the date of fda 3 and this is where 15-mar-06 would appear thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open an input screen
For a calendar control:
http://www.rondebruin.nl/calendar.htm for userforms and commandbuttons: See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 Here are some other sources of information: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://support.microsoft.com/default...b;en-us;829070 http://support.microsoft.com/?id=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 File Name: WE1163.EXE File Size: 161742 bytes File Date: 05/08/97 Keywords: kbfile Description: 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 Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en.../Introductiont... Part II http://msdn.microsoft.com/library/en.../Introductiont... -- Regards, Tom Ogilvy "cityfc" wrote in message ... please help i have a list of names each with a button next to it and when pressed i would like to open a form with their name in it. also in this form i would like a drop down list with FDA 1, OTDR 1, FDA 2, INTERIM, FDA 3, OTDR 2, FDA 4, SUMMARY. next to this is it possible to have a date picker so to make it easier for the inputter. now when they press ok i want the date placing below the relevant item for instance: if they chose fda 3 and date 15-mar-06 and pressed ok. cell g5 is the space for the date of fda 3 and this is where 15-mar-06 would appear thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Can I move the excel input box to the bottom of my screen. | Excel Discussion (Misc queries) | |||
how to input a signature via my touch screen into excel | Excel Discussion (Misc queries) | |||
Screen goes black when trying to open excel | Excel Discussion (Misc queries) | |||
Input Screen | Excel Discussion (Misc queries) |