PDA

View Full Version : UserForm? question



deltapro
11-27-2008, 01:39 PM
Hi,
On the UserForm I have several textboxes and few Comboboxes. One of the combos is pulling dates from the column A on the spreadsheet. How do I find out:
1. In which row this date is and how to
2. Insert texbox.value in appropriate range in this row.
3. Since there is over 70 textboxes how do I automate this process(button?)

Thanks
Jack

Simon Lloyd
11-27-2008, 01:45 PM
For the combobox getting the dates you will need to supply the code you are using to populate the combobox, once we have this we can help you with the automation, you will also need to tell us what the "appropriate" range is!

deltapro
11-27-2008, 02:47 PM
I'm using RowSource property, by "appropriate" I mean - each tbox.value is always placed in it's own column, date dictates row placement- I.e. TextBox1.Value will always be in the B column. If user picks Jan/15/09 from ComboBox , TB1.Value will be placed in B16.

Regards
Jack

Simon Lloyd
12-05-2008, 10:20 AM
Jack, your last post was no clearer, why not attach a workbook so we can see what your problem is.

mdmackillop
12-05-2008, 10:40 AM
Something like this?