Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am new to Excel forms and VBA.I have created a form to fill data to selected cells of a worksheet.I have two combo boxes from which the user can select predefined values and some text boxes.The data needs to be filled depending on these two combo box selections. To illustrate this let us take a worksheet which has names of items nos in cells A2:A10.Range B2:B13 contains the months Jan to Dec.The combo box selects item no and month.The data is from text box is filled to the respective cell depending on month and item no. I have done the job by using select case procedure but this becomes very long for a large worksheet and multiple criteria.Please help me with some alternative method like search/find etc. Thanks P.Mundle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
Selecting rows based simultaneously on 3 criteria | Excel Programming | |||
VBA - Selecting Based on Criteria | Excel Programming | |||
Selecting Sheets based on Cell Criteria. | Excel Programming | |||
selecting and deleting a row based on a cell value | Excel Programming |