view code & properties

A

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
 
B

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)
 
A

aggierian

You need to set excel to design mode

open the visual basic toolbar and click the design mode buto
 
A

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
 
A

aggierian

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