Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting Button Just Activated (help!)


Hey everyone! I was wondering if there is code that will make excel
select a button that has just been activated. So, in other words, when
you click the button to activate it, part of the code in the macro will
select the button that was just activated. I hope thats clear to
everyone! I appreciate your help.


--
jpizzle
------------------------------------------------------------------------
jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920
View this thread: http://www.excelforum.com/showthread...hreadid=376707

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting Button Just Activated (help!)


well, I was looking to be able to select the button that was just
clicked without referencing its name.


--
jpizzle
------------------------------------------------------------------------
jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920
View this thread: http://www.excelforum.com/showthread...hreadid=376707

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting Button Just Activated (help!)


Well, I don;t know if thats possible. But when you click on a particular
button, you know beforehand what button it is. Maybe if you give your
real scenarion, someone could help.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376707

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting Button Just Activated (help!)


I guess you are looking for something like:
CommandButton1.Select

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376707

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
selecting more than one option button Katie-Baughman Excel Discussion (Misc queries) 4 May 6th 05 02:24 PM
Is it possible to change the blue colour of an activated Auto Filter button? Marcel Wilmink via OfficeKB.com Excel Discussion (Misc queries) 1 February 24th 05 08:35 PM
Tab selecting a button with assigned macro ob3ron02[_18_] Excel Programming 0 November 2nd 04 06:18 PM
selecting workbook/worksheet from browse button monika Excel Programming 9 February 8th 04 09:40 AM
Selecting a random number from a set criteria by clicking a button Caitlin[_2_] Excel Programming 1 November 6th 03 12:12 PM


All times are GMT +1. The time now is 07:10 AM.

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

About Us

"It's about Microsoft Excel"