Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Swapping two ranges
Please give me some help with swapping identically sized ranges. I have several ranges and what I would like to do is have one button assigned to each range . Here is how this would work There is a variable which is normally set to zero. I press a button the first cell in its range changes text color t indicate that the button press has been registered and the variable is changed. The color change and variable value have a time out. If a second button isnt press before the timout the variable goes bac to zero and the cell text is returned. If a second button is pressed before the time out the a swap take place. The variable is used by the sub to determine which range was chosen by the first button press. Note: the sub distinguishes between a 1st press and a 2nd press by the variable... a zero determines that it is a 1st button press. Each button calls the sub with a different variable some of the questions I have are what is the basic structure code to swap 2 same sized ranges? how do I write code that holds conditions true for only set amount o time? where would I Dim my variable? It needs to reside outside the sub. any help is greatly appreciate -- SuitedAce ----------------------------------------------------------------------- SuitedAces's Profile: http://www.excelforum.com/member.php...fo&userid=3584 View this thread: http://www.excelforum.com/showthread.php?threadid=55674 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Swapping headers | Charts and Charting in Excel | |||
swapping axis' | Charts and Charting in Excel | |||
Swapping columns | Excel Programming | |||
swapping columns?? | Excel Discussion (Misc queries) | |||
Swapping Values | Excel Programming |