Hi guys
I'm not experienced in writing vba code. I have created an activex combobox to enable me to quickly move to another worksheet in my workbook. I have managed this mostly by following youtube videos lol!
It works perfectly (surprisingly) BUT every time I click into the box the text within it shrinks and also the size of the box changes when I come back to the worksheet with it on.
I am working in Excel 2010 on windows10 64bit.
I have attached the file accordingly and the combobox in question says 'Go To Batch'
I have googled the problem and searched on here to no avail so far and just wondered if someone could help me.
Many thanks in advance
Andy
I'm not experienced in writing vba code. I have created an activex combobox to enable me to quickly move to another worksheet in my workbook. I have managed this mostly by following youtube videos lol!
It works perfectly (surprisingly) BUT every time I click into the box the text within it shrinks and also the size of the box changes when I come back to the worksheet with it on.
I am working in Excel 2010 on windows10 64bit.
I have attached the file accordingly and the combobox in question says 'Go To Batch'
I have googled the problem and searched on here to no avail so far and just wondered if someone could help me.
Many thanks in advance
Andy