F5 goto object

[kelvin_9]

if I have some photos stored with command button page
Is there any way that I can delete the photos only but not command button together by F5/goto/object

if no, any macro that can do it?
I had around 200photos in column F

thanks for the help

 

[kelvin_9]

Change your options to show the Developer tab in the ribbon, then you can use the Insert dropdown on that tab.

JESUS!!
how can it be work prefect like this and actually what is the different between form control and activex control?

thanks you two

 

[RoryA]

Form controls are part of Excel, so they are actually more stable on worksheets than Activex ones, so if you can use them (they have fewer formatting options and VBA events), you're better off doing so.

 

[kelvin_9]

Change your options to show the Developer tab in the ribbon, then you can use the Insert dropdown on that tab.

hi RoryA
i'd like to ask, if i have 4 module and 50 macro each, how can i use userform under form control button?
ps: i've draw a combobox under userform.
thanks

 

[RoryA]

I don't understand the question. The number of modules/macros has no bearing on whether you can use a Form control to load a userform. You just need to create a macro to show the form using userformname.show