Combo box text keeps growing

MrHaggis

New Member
Joined
Oct 6, 2006
Messages
18
Hi all,
I've got a combo box that I want to use to take users to various areas of the spreadsheet. It's populated by a lookup list that has the target range name in column 3 (the bound column). The code I'm using (and this could be my problem - I'm new to VBA)is:

Sub GoToRoom()
Dim nmRoom As String
nmRoom = Range("roomchoice")
Range(nmRoom).Activate

roomchoice is the linked cell of the combo box

It seemed to work fine. Problem is, the font inside the combo box gets bigger and bigger each time a selection is made, until it's too huge to be seen inside the box. When I open the properties of the combo box (control toolbar) and change the size of the box slightly, the font drops back down to normal.

Anybody know what I'm doing wrong??
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,136,517
Messages
5,676,319
Members
419,619
Latest member
jalme

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top