I am trying to use a Control-form dropdown on my spreadsheet.

The usual way this sheet it viewed is at maximum zoom-out. I have made the
dropdown larger but the text needs to be much larger to be read. I have
searched through both manual settings and code settings but I can't find
anything that even hints that this is possible. How do I accomplish this?

--
Regards,
John

I generally use the dropdown from the 'Control Toolbox'. To change the font,
right click when in design mode and select properties. Double-click on the
font property and select the font size.

JNW

"John Keith" wrote:

I am trying to use a Control-form dropdown on my spreadsheet.

The usual way this sheet it viewed is at maximum zoom-out. I have made the
dropdown larger but the text needs to be much larger to be read. I have
searched through both manual settings and code settings but I can't find
anything that even hints that this is possible. How do I accomplish this?

--
Regards,
John

That has a lot of features that I could probably use If I could convert from
the form to the control. But I have had no luck doing that.

Can you point me to a simple tutorial or example that show how to implement
the form as a control?

I have tried several methods to do what I need:

DataValidation allow:"List" Source:"=indirect(B1)"
I have a ListRange that is dynamic. The list is in ColumnA. A Range
reference to Column A is built with ="A1:A"&countif(A:A," ")
I can make the font size 70 and the Selected value is large but the
drop-down list is still tiny.

Combo-Box Form:
InputRange cant be an indirect reference.. but I can control the values via
VBA code setting the .ListFillRange .LinkedCell .DropDownLines and
..Display3dShading.

Neither of these options allow font size changes to the Actual list that
shows for selection. Will the Control version?

I may try making the drop down a command bar, I have Bullen, Bovey and
Green's book on Professional Excel Development which shows a nice way of
doing that. (it's still a bit complex for my skill-set But I'm learning)

Although I'd still like to see a simple explanation of how to convert a form
to a control (combo-box - specifically) I.E. which code goes where to
accomplish the features that are found in the form.
--
Regards,
John


"JNW" wrote:

I generally use the dropdown from the 'Control Toolbox'. To change the font,
right click when in design mode and select properties. Double-click on the
font property and select the font size.

JNW

"John Keith" wrote:

I am trying to use a Control-form dropdown on my spreadsheet.

The usual way this sheet it viewed is at maximum zoom-out. I have made the
dropdown larger but the text needs to be much larger to be read. I have
searched through both manual settings and code settings but I can't find
anything that even hints that this is possible. How do I accomplish this?

--
Regards,
John