Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading Forms in Sheets...
Ok, i cant find anything... I want to put form data in a sheet, but I cant figure out how to do it. Just for clarification, I was in a sheet. Using the View Toolbars Forms I created some list boxes. So, how do I populate them and read from them? SOMEONE HELP ME! thanks =) -- Budfroggy ------------------------------------------------------------------------ Budfroggy's Profile: http://www.excelforum.com/member.php...o&userid=31211 View this thread: http://www.excelforum.com/showthread...hreadid=508832 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading Forms in Sheets...
"Budfroggy" wrote: Ok, i cant find anything... I want to put form data in a sheet, but I cant figure out how to do it. Just for clarification, I was in a sheet. Using the View Toolbars Forms I created some list boxes. So, how do I populate them and read from them? SOMEONE HELP ME! thanks =) -- Budfroggy ------------------------------------------------------------------------ Budfroggy's Profile: http://www.excelforum.com/member.php...o&userid=31211 View this thread: http://www.excelforum.com/showthread...hreadid=508832 If you want to e.g select months Write jan to dec in a column (under each other) Hold down control and dubble click your menue. Select dialog page Control select Input Range and select jan-dec on your spreadsheet. Select Cell link and select a cell for the result 1-12 according to selected line or month. Hit OK Use the result cell for formulas or control. Recomendation: Name thath vector by typing e.g. Months in cell address or by using Insert/Mane/Define menue. Name one cell for your answer This vill be easier to use, cange and refer to Good Luck LindhJonas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reading from SQL | Excel Discussion (Misc queries) | |||
RefEdits and normal forms / forms in a DLL | Excel Programming | |||
Forms that open from forms | Excel Programming | |||
Private forms and sheets | Excel Programming | |||
Calling Forms from Forms - Exit problems | Excel Programming |