| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells not changing selection after sheets array
Tom,
Prior to using a userform i used a listbox, this worked fine when used validation, allow list......when i selected a cell i would get listbox dropdown list and the macro on each sheet was to select al sheets....this worked fine and your selection would go where you put i and would be in the same place across all sheets...but now i have go the program looking smarter using a userform it doesnt work right... have mailed you a short rip off from my 21 sheet workbook, as it i 780k which is too big for this forum. Simo -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
![Simon Lloyd[_480_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
