| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop downs in Data Form
Hi there, I have been using the form option in the data menu to input info like a database. One of my columns is uses validation with a dropdown menu. Is there anyway to have that dropdown show up when inputting in forms? -- Gator9 ------------------------------------------------------------------------ Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752 View this thread: http://www.excelforum.com/showthread...hreadid=484386 |
|
#2
|
|||
|
|||
|
Drop downs in Data Form
You could try John Walkenbach's Enhanced Data Form. It's a free add-in
that allows combo boxes, so it could display a list of items. http://j-walk.com/ss/dataform/index.htm Gator9 wrote: Hi there, I have been using the form option in the data menu to input info like a database. One of my columns is uses validation with a dropdown menu. Is there anyway to have that dropdown show up when inputting in forms? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Drop downs in Data Form
tahnks this is great. One question. When using the original data form, I coul use my headings from any row. This seems to allow me only to use the first row. Is there a way around that? -- Gator9 ------------------------------------------------------------------------ Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752 View this thread: http://www.excelforum.com/showthread...hreadid=484386 |
|
#4
|
|||
|
|||
|
Drop downs in Data Form
If you leave an empty row before the header row, then it should work ok.
It looks like it uses the same range as you get when you do: edit|goto|special|current region (or ctrl-*) Gator9 wrote: tahnks this is great. One question. When using the original data form, I coul use my headings from any row. This seems to allow me only to use the first row. Is there a way around that? -- Gator9 ------------------------------------------------------------------------ Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752 View this thread: http://www.excelforum.com/showthread...hreadid=484386 -- Dave Peterson |
|
#5
|
|||
|
|||
|
Drop downs in Data Form
Ps. If you want to customize it more, you can buy the password to the code for
$20 (USA). Gator9 wrote: tahnks this is great. One question. When using the original data form, I coul use my headings from any row. This seems to allow me only to use the first row. Is there a way around that? -- Gator9 ------------------------------------------------------------------------ Gator9's Profile: http://www.excelforum.com/member.php...o&userid=28752 View this thread: http://www.excelforum.com/showthread...hreadid=484386 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| data entry form Excel | Excel Discussion (Misc queries) | |||
| How to..use worksheet form and save data to an Excel list | Excel Discussion (Misc queries) | |||
| How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
| How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
Linear Mode
