Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Swapping headers Darren Charts and Charting in Excel 2 January 25th 10 06:51 PM
swapping axis' baltobernie Charts and Charting in Excel 5 June 25th 09 02:42 AM
Swapping columns Daminc[_62_] Excel Programming 0 March 27th 06 01:43 PM
swapping columns?? Johnny D Excel Discussion (Misc queries) 0 February 15th 06 07:13 PM
Swapping Values Don Lloyd Excel Programming 4 November 4th 04 06:53 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"