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

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