Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emulate Access with Excel - display form for data entry
Hi everyone
Can anyone give me any pointers as to creating a form to allow data to be entered into columns in an Excel spreadsheet. I know I can use "Data"- "Forms" from the menu bar but I need something a bit more advanced. I started to create one from the forms toolbar but then I wasn't sure wether I should create one from the control toolbox bar. Does anyone know of any sites containing tutorials etc. Kenny at work |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emulate Access with Excel - display form for data entry
Hi Kenny
have a look at http://j-walk.com/ss/dataform/index.htm HTH Frank Kennyatwork wrote: Hi everyone Can anyone give me any pointers as to creating a form to allow data to be entered into columns in an Excel spreadsheet. I know I can use "Data"- "Forms" from the menu bar but I need something a bit more advanced. I started to create one from the forms toolbar but then I wasn't sure wether I should create one from the control toolbox bar. Does anyone know of any sites containing tutorials etc. Kenny at work |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emulate Access with Excel - display form for data entry
Kenny,
If the DataForms isn't good enough for you, I would definitely suggest a userform not control toolbox. You will need an initial form for adding a new, or showing existing for amending or deleting. You might want some sort of spin control for cycling through the records as well as allowing user to pick directly, similar to DataForms. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kennyatwork" wrote in message ... Hi everyone Can anyone give me any pointers as to creating a form to allow data to be entered into columns in an Excel spreadsheet. I know I can use "Data"- "Forms" from the menu bar but I need something a bit more advanced. I started to create one from the forms toolbar but then I wasn't sure wether I should create one from the control toolbox bar. Does anyone know of any sites containing tutorials etc. Kenny at work |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emulate Access with Excel - display form for data entry
Thanks for your speedy responses - Ill give them a try
Kenny "Kennyatwork" wrote in message ... Hi everyone Can anyone give me any pointers as to creating a form to allow data to be entered into columns in an Excel spreadsheet. I know I can use "Data"- "Forms" from the menu bar but I need something a bit more advanced. I started to create one from the forms toolbar but then I wasn't sure wether I should create one from the control toolbox bar. Does anyone know of any sites containing tutorials etc. Kenny at work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel template as form for data entry in Access database | Excel Discussion (Misc queries) | |||
Excel as data entry form? | Excel Discussion (Misc queries) | |||
Is it possible to emulate a ten-key entry in Excel? | Excel Discussion (Misc queries) | |||
Data Entry Form Connect With Access | Excel Discussion (Misc queries) | |||
data entry form in excel | New Users to Excel |