ArthurNyunt
New Member
- Joined
- Feb 12, 2004
- Messages
- 12
Hi everyone,
I have a couple of questions regarding drop downs
I have noticed that there is two different ways to create drop down boxes, one using a more conventional VB format using the control toolbar and the other using the Forms toolbar
I have used the VB format to create my drop down which works fine if you view it normally but is disabled when you view the document via a web browser. Is there any way you can enable this ?
If it is not possible to enable the control I would consider using the second method but would like to know
If you can add options via code or do you have to link it to a range of cells
If you can determine the selection of the drop down via a code rather than having a linked cell which displays the index of the option
thanks
I have a couple of questions regarding drop downs
I have noticed that there is two different ways to create drop down boxes, one using a more conventional VB format using the control toolbar and the other using the Forms toolbar
I have used the VB format to create my drop down which works fine if you view it normally but is disabled when you view the document via a web browser. Is there any way you can enable this ?
If it is not possible to enable the control I would consider using the second method but would like to know
If you can add options via code or do you have to link it to a range of cells
If you can determine the selection of the drop down via a code rather than having a linked cell which displays the index of the option
thanks