LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default q: is this possible in vba - multiple command buttons..

Hey Folks,

I have a userform which as a series of three checkboxes per line. Beside
these checkboxes, I have a command button - the reason is so the use can
hit the button to flag on or off the checkboxes in the row to which it
corresponds rather than individually ticking each one, if all apply.

A graphical way it as such: Where @ is the command button and * is the check
box

@ * * *
@ * * *
@ * * *
etc

Rather than programming 25 subprograms... one for each command button, is it
possible to have one sub or function to cater to the overall workings?

If not... is it possible to return the values of relevant regions that the
mouse button is clicked on on the userform? This way i can draw on the
userform or place images and just have it determine the userform was clicked
on and work out where it was clicked as a defactocommand button.

Help is greatly appreciated. Thank You In Advance.


 
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
Command Buttons msals22[_3_] Excel Programming 2 June 21st 06 09:43 PM
command buttons kevatt[_22_] Excel Programming 3 March 19th 06 02:31 PM
Command buttons etc TimO Excel Programming 1 July 28th 04 06:55 AM
Control Buttons vs. Command Buttons Robert Gibson Excel Programming 1 October 13th 03 04:33 PM
Command buttons not available Donna Brooks Excel Programming 0 August 25th 03 04:23 PM


All times are GMT +1. The time now is 05:40 PM.

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"