view code & properties

[alexanderd]

having placed an edit/list box in an excel file i find that i am unabl
to alter the properties or view the code when i right click on
edit/list box.
how can this be achieve

 

[Bob Phillips]

Have you created it from the controls toolbox? If so, select it, right-click
on the sheet tab, and select View Code. You should see the properties in the
VBE then.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[aggierian]

You need to set excel to design mode

open the visual basic toolbar and click the design mode buto

 

[alexanderd]

thank you for your quick response, i have done that to no avail.

what i have is a drop down list on an excel form and when i right clic
on the list i get a menu, i wish to place in this floating menu th
properties and view code

 

[aggierian]

When excel is in design mode they should automaticly be there. I am no
sure if they can be viewed any other wa