View Full Version : UserForm? question

11-27-2008, 01:39 PM
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?)


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!

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.


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.

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