Userform combobox lists

Hi Louisa

Thanks for getting in touch. With regards to your dates, it is best to use the Format function to control them. You could then employ it in the Initialize event.

To create an Initialize event, double click an empty area of your userform, then change the drop-down to the top-right of the VBE to "Initialize". Code entered here will be executed when the form loads.

If you had a label called "Label1" and your date was in cell A1, then you could format it like this:

Label1.Caption = Format(Range("A1"), "dd/mm/yyyy")

With regards to controlling the pointer, the order is controlled by a property called TabIndex. This is in the order that the controls were created. Over time controls are deleted and moved and the order changes. To reset this again put code like this in the Initialize event:

TextBox1.TabIndex = 1
ComboBox1.TabIndex = 2
CommandButton1.TabIndex = 3

And keep adding indexes as required.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector