View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cadcamguy cadcamguy is offline
external usenet poster
 
Posts: 11
Default Which control is the one selected?

Is there a way to tell me which control is being worked with.. returning
that controls name

I have a vba program in Excel and I guess control arrays aren't an option.
But I can fake it
downside is I want to be able to add some more controls... it just textboxes
labels check boxes
nothing fancy.. I have a numeric only option for the textbox..

but what I am doing is just copying and pasting the code for how ever many
textboxes there are...
just seems like I could make it a function if I could return which control
it is

It's not a big deal by any means.. just would make it simpler to add more

Tia