Navigation

Hi,

I've got many activex controls in individual excel cells

Is there a way to determine in any cell if a control exists in it?

I'm manually creating a keydown event for every control to create a tab & shift+tab through the controls (and also selecting the cells they are in, that way the sheet moves with it).

This is a very tedious process. Has anyone done this before? Is there an easier way?

Thanks!

Hi steven_b46,

Is there a way to determine in any cell if a control exists in it?

The only way I know of doing this is to determine the coordinates of the cell, and then iterate through all controls on the sheet, and determine if one or more controls and the cell intersect.

---------------------
The approach I like to take is to create the controls programmatically (one time only during Workbook design), and rename the controls to coincide with the cell in which they reside. For example an Active X text box in cell B7 would be named 'TextBoxB7'. It is relatively easy for the event handler to extract the Cell Address from the Control Name.

See the attached file which:
a. creates several Active X Text Box controls using the naming convention above
b. uses a 'Class Event Handler' so that one Macro can process all Active X controls of the same type.
c. currently has 'Event Handler' capability for 'Double Click' and 'Change' events.

Lewis

Thanks!!! I will look this over.

OK, this works (thanks again), when I put this in my project, I get an error on

Please Login or Register  to view this content.

I see this in intellisense in what you sent, but not my project, so I'm doing something wrong?

Ideas?

Disregard, I'm an idiot. I see what is going on.