View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jeff Ciaccio Jeff Ciaccio is offline
external usenet poster
 
Posts: 17
Default How to set a tab stop for a command button

Can I set a tab stop to bring the focus to the button?

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if it was created with the forms toolbar, just right click on it and
choose assign macro to see what the code is

go to the vb editor to view the code in the module.

if it was created with the control toolbox, then go to the vbe editor and
doubl click the sheet name it resides on under excel objects.

--


Gary


"Jeff Ciaccio" wrote in message
...
I have put a command button on a sheet, and there is code behind it, but I
don't know how to view that code. I have tried going to design mode and
double clicking, but it just runs the procedure. If I'm in the VBA
environment, where do I go to see the code and the properties for a
command button?

I have only a few cells unlocked, so the tab stops go to only those. Is
there a way to make another tab stop on the command button?

Thanks!

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio