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
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!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
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
Jack, your last post was no clearer, why not attach a workbook so we can see what your problem is.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Something like this?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
