Loading...

Excel 2010 Fix ComboBox Size for VBA

19,375 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 7, 2011

http://www.contextures.com/xlDataVal1...

With Excel data validation, you can create drop down lists on a worksheet. However, the font size is very small, and can't be adjusted, and you can only see 8 items at at time.

With Excel VBA programming, you can add a ComboBox to the worksheet, that lets you control the font size and the number of visible items in the list.

If you're using this technique in Excel 2010, you might have a problem with setting the ComboBox size.

This video shows how to change the size setting, so the ComboBox will work correctly in Excel 2010.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...