I Have a sheet with many ranges, when i push the commandbutton I need it to insert the selected cell in textbox 1 witch works but it needs to insert the full range into textbox 2, 3, 4, 5, 6. I have attached an example.
I Have a sheet with many ranges, when i push the commandbutton I need it to insert the selected cell in textbox 1 witch works but it needs to insert the full range into textbox 2, 3, 4, 5, 6. I have attached an example.
Last edited by Sniper; 01-19-2010 at 08:04 AM.
Are you trying to use TextBoxes to define ranges?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
yes, but i need it all to be automatically.
My problem is that when i push the commandbutton on the spreadsheet it brings up the userform and insert the active cell address in textbox1 and nothing in the other textboxes - it needs to say : textbox1 = A5, Textbox2 = A10, Textbox3 = B5, Textbox4 = B10, textbox5 = C5 & Textbox6 = C10. I want it to look at the value in textbox1 and return the value + 5 in textbox2, it needs to then + next column = B and add it to textbox 3 etc.
Can anyone please help me with this problem??
Hi everyone, find attached the solution to this problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks