Re: Limiting the cells a command button can change

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/03/04 

Date: Tue, 3 Feb 2004 10:02:15 -0500

if Not intersect(selection,Range("B9:H20")) is Nothing then

change selection to activecell if that is preferred. 

-- 
Regards,
Tom Ogilvy
"Matt" <anonymous@discussions.microsoft.com> wrote in message
news:65220C8B-7F98-440B-8C55-397470BD4295@microsoft.com...
> I have a command button that when clicked, it changes some of the cell
properties.  I would like to limit the cells that the command button can
change.  I would like to say that if the activecell is within a range, then
make the changes.  Otherwise if not, exit sub.  I'm not sure how to write
the code so that the button is limited to a certain range of cells.  Thanks
for any help.  Matt

Relevant Pages

  • Re: Access CommandButton "On Click" property
    ... Dim cnt As DAO.Container ... > each command button in the design view of the form, ... Matt ... > write the value of their Click event properties to a table. ...
    (microsoft.public.access.macros)
  • Re: sedding away but chmod dont like...]
    ... Ronald van Zantvoort wrote: ... >> Matt M ... ksh isn't removing the quotes because they result from expanding the ... command subsititution. ...
    (comp.unix.solaris)
  • Re: SCP problem
    ... > Matt Bostock enlightened us with: ... > you tell 'scp' to copy a directory. ... The second command tells scp to copy ... > The problem with the world is stupidity. ...
    (alt.os.linux)
  • Re: Excel- command button- click event needs to work
    ... Is the command button from the Control Toolbox or Forms Toolbox? ... the activecell isn't lost when you click the button. ... >> Microsoft MVP - Excel ...
    (microsoft.public.office.developer.vba)
  • Re: auto filter use with command button
    ... I assume that where you are using Target, you mean the ActiveCell. ... with the Command Button). ... If ActiveCell.Address inputCell Then ...
    (microsoft.public.excel.worksheet.functions)