Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Textbox accross worksheets - wont work!
I've got info in cells in a workbook that has multiple worksheet.
I've created a macro that has mulitpage, and accesses and has to change values in different sheets at different times. In most of the objects you can just specify Worksheets2.Activate if you want sheet 2, but all the text boxes reference to the cells in one sheet, so when the user uses the user form to input a value - the right cell gets changed, but on the wrong sheet! Anyone know how to specify the sheet number? Would be greatly appreciated - this has sucked my time.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum accross worksheets using names | Excel Worksheet Functions | |||
Can't figure out why Macro wont work???? | Excel Worksheet Functions | |||
form textbox wont word wrap | Excel Programming | |||
macro wont work | Excel Programming |