R
RamblinWreck
I need some quick help from a forum "expert". In my younger naive days
I wrote a spreadsheet that has about 30 drop down menus via th
combobox button from the forms menu.
Many people use this spreadsheet - including my new boss who has ba
eyesight. Well, the new boss requested that I increase the font siz
of the drop down menu which can't be done with the forms combobox.
However, the font size of the drop down menu can be easily changed on
control combobox.
The problem is that the output (the linked cell) of a control combobo
is the excact text from the drop down menu. This is a problem as th
linked cell form the forms combobox is a numeric value, and ALL of m
logic is predicated on the numeric value.
Yes, I can use the VLOOKUP function to convert control combobox outpu
to a numeric value, but that's a pain. Is there a way (perhaps via
properites setting) to change the output of the control combobox fro
the text vaule to a numerical value ?
Also, please understand that I am not lazy. I spent about an hou
searching this forum and other forums for the answer to my question
but I got nowhere. I guess I just don't know how to search !
Many thanks for your patience in reading this
I wrote a spreadsheet that has about 30 drop down menus via th
combobox button from the forms menu.
Many people use this spreadsheet - including my new boss who has ba
eyesight. Well, the new boss requested that I increase the font siz
of the drop down menu which can't be done with the forms combobox.
However, the font size of the drop down menu can be easily changed on
control combobox.
The problem is that the output (the linked cell) of a control combobo
is the excact text from the drop down menu. This is a problem as th
linked cell form the forms combobox is a numeric value, and ALL of m
logic is predicated on the numeric value.
Yes, I can use the VLOOKUP function to convert control combobox outpu
to a numeric value, but that's a pain. Is there a way (perhaps via
properites setting) to change the output of the control combobox fro
the text vaule to a numerical value ?
Also, please understand that I am not lazy. I spent about an hou
searching this forum and other forums for the answer to my question
but I got nowhere. I guess I just don't know how to search !
Many thanks for your patience in reading this