Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Command - Not Familiar With Program
I am looking for a VBA Command for the following situation . . . .
it possible that when a user choses an action from that list that rows can be inserted and new data entered . . If User chooses "Sample" . .from the list in Row 1 . . . can i create a function that will insert one row when Sample is chosen (Insert Row 2) . . but if User chooses Inspect . . .from the list in Row 1 . . .can the "function" insert three row (Insert Row 2, 3, & 4) . . .Currently Row 1 contains several columns of data describing a particular location and the work that has been currently completed on the site . .one location can be used once or can be used multiple times. . . . each location is unique . .none the same . . .i want to be able to not have to write all the info. over and over again . . . Row 2 would contain several columns of information for a new location . . .i would like to create a function that would allow the user to enter more data on location in Row 1 if need be . .dependant on the work that might have to be completed . . .Sample, Inspect, Mix . . . Is this possible . . please let me know if you require more information . . Once again i appreciate your time . . Please let me know if you require more information .. . i am a rookie when it come to this sort of thing . . . thanks for your time . . . . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is anyone familiar with the pull formula in excel? | Excel Worksheet Functions | |||
Hyperlink or Command Button Program | Excel Programming | |||
Command line program use in VBA | Excel Programming | |||
Anyone familiar with BPCS? | Excel Programming | |||
familiar with Oracle Objects for OLE? | Excel Programming |