Command Button

macropod · #8 02-27-2011, 08:47 PM

Hi Brock,

Quote:

I am trying to avoid the userform as then the user, as you noted, will have to select the range.

No, a user-selected range isn't the only option. You might be able to determine the range to act on programmatically, independently of what the user might have selected, or use the user's selection as a reference point from which to programmatically determine the range to act on (eg by reference to the page # or document Section that the selection point is in). Without knowing your requirements, it's hard to say what the best approach might be.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Where is the undo command	Codey	Excel	1	06-15-2010 01:10 PM
Using the LOOKUP Command	Grapejuice	Excel	2	10-15-2008 02:02 PM
Add-In:How to add command right click command bar	phang	Outlook	0	01-15-2007 02:53 AM
command buttons	ronf	Excel	0	04-28-2006 08:32 AM
command buttons	ronf	Excel	0	12-03-2005 06:26 AM