Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a dialog box to input information to worksheet?
I'd like to create a dialog box to input information such as "client's name",
"address"', "date of visit", etc... dialog box should also function as search tool to locate details of client once any information of the client is encoded in search section. -- joromajr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a dialog box to input information to worksheet?
You can use excels built in dataform to do what you want.
Assuming your data is laid out in a database table like format with Row 1 used for Headers - place this code in standard module & run. A form should appear where you can add, delete search etc your data. Sub ShowForm() With ActiveSheet .Range("A1").Select .ShowDataForm End With End Sub Hope helpful -- jb "joromajr" wrote: I'd like to create a dialog box to input information such as "client's name", "address"', "date of visit", etc... dialog box should also function as search tool to locate details of client once any information of the client is encoded in search section. -- joromajr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a dialog box to encode information to worksheet? | Excel Discussion (Misc queries) | |||
How to create dialog box that will post to worksheet encoded data? | Excel Discussion (Misc queries) | |||
create template with certain fields to input information only | Excel Worksheet Functions | |||
Dialog box with worksheet information | Excel Worksheet Functions | |||
How do can I create a Excel worksheet from information on a templa | Excel Discussion (Misc queries) |