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??
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??
