2 quick questions...

[cob98tp]

Ok first 1... (I'm using Excel 97)

Is there a way of turning off screen updating while a macro runs? I have a macro that takes about 30 mins to run and I was hoping that if I turn off the screen updating it may speed up slightly. (I'm sure I saw a way of doing this but I can't find it again!)

Second question is about combo-boxes. How do I go about increasing the size of the text in one of my combo-boxes?

thanks all for your time!

 

[SteveO59L]

Try Application.screenupdating = false as the first line of your code.

 

[~Zodiac~]

Screen updating

Application.ScreenUpdating = False 'to disable it

Application.ScreenUpdating = True 'to enable it

amount of columns in a combobox
look for the property TextColumn of the combobox and adjust the value next to it to be the needed number of columns

Text shown in the combobox

type whatever you want to see in the combobox next to the property "Value"

Adding multiple items to a combobox (dropdown menu)

ComboBox1.DropDown
ComboBox1.AddItem "Item1"
ComboBox1.AddItem "Item2"
enz


HTH

 

[cob98tp]

Thanks for the help! I've managed to sort both problems out with your tips.