| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 03 Trying to create input form
I just can't figure out how to create a simple input form that will put the
data into the worksheet for simple use for someone that doesn't know excel well. Within that form i need to use drop down menus that I created using Data Validation. I don't know why I can't figure out how to make this work, like in Acess Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 03 Trying to create input form
I don't speak the Access, but if you want to learn about Data|Validation, start
at Debra Dalgleish's site: http://contextures.com/xlDataVal01.html Tbram wrote: I just can't figure out how to create a simple input form that will put the data into the worksheet for simple use for someone that doesn't know excel well. Within that form i need to use drop down menus that I created using Data Validation. I don't know why I can't figure out how to make this work, like in Acess Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 03 Trying to create input form
This places Text into the cell.
Sub Get Information() Information = InputBox ("Enter Information about ") Range ("A1") = Information End Sub :) -- William<"M" "Tbram" wrote: I just can't figure out how to create a simple input form that will put the data into the worksheet for simple use for someone that doesn't know excel well. Within that form i need to use drop down menus that I created using Data Validation. I don't know why I can't figure out how to make this work, like in Acess Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 03 Trying to create input form
Excel has a simple Data Form found under DataForm.
As far as why you can't figure out how to make this work...........very difficult to trouble-shoot from here without more detail. What do you consider as a "form" to start with? Just a series of cells that users enter data into? Gord Dibben MS Excel MVP On Wed, 2 May 2007 09:49:00 -0700, Tbram wrote: I just can't figure out how to create a simple input form that will put the data into the worksheet for simple use for someone that doesn't know excel well. Within that form i need to use drop down menus that I created using Data Validation. I don't know why I can't figure out how to make this work, like in Acess Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 03 Trying to create input form
Yes - thanks. I've created a nice spreadsheet to enter data into but they
would rather have a form to enter the data without seeing the rest of the entries. and as that info is inserted, it will compile in the database thanks Tina "Gord Dibben" wrote: Excel has a simple Data Form found under DataForm. As far as why you can't figure out how to make this work...........very difficult to trouble-shoot from here without more detail. What do you consider as a "form" to start with? Just a series of cells that users enter data into? Gord Dibben MS Excel MVP On Wed, 2 May 2007 09:49:00 -0700, Tbram wrote: I just can't figure out how to create a simple input form that will put the data into the worksheet for simple use for someone that doesn't know excel well. Within that form i need to use drop down menus that I created using Data Validation. I don't know why I can't figure out how to make this work, like in Acess Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
| Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
| How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
| How do you embed an input form into excel? | Excel Worksheet Functions | |||
Linear Mode
