VBA coding of Userform help needed please

[Alexph]

Hi
I am very new to Excel VBA. I am running Excel for Mac 2011. i have created the spreadsheet and I have created the user form that I want to use for data entry - its 8 fields/labels and 2 command buttons.

I am totally stuck on how I start to create the actual code. Can anyone recommend a good crib sheet that I can use?

many thanks

A

[Cutter]

Perhaps this site will help you:
http://www.contextures.com/xlUserForm01.html

or this one:
http://www.exceltip.com/st/Create_Us...Excel/629.html

[Alexph]

Thank you for the help

I have coded my form as follows:
Private Sub frmPostage_Initialize()
TxtDate.Value = ""

With cboBusiness
.AddItem "Hulu Limited"
.AddItem "Moustraining"
.AddItem "The Modbury Group"
End With
cboBusiness.Value = ""

With cboService
.AddItem "Packet Post"
.AddItem "Letter"
.AddItem "Tracked"
End With
cboService.Value = ""

With cboClass
.AddItem "First"
.AddItem "Second"
.AddItem "EU"
.AddItem "ROW"
.AddItem "Special Delivery"
End With
cboClass.Value = ""

With cboService
.AddItem "Packet Post"
.AddItem "Letter"
.AddItem "Tracked"
End With
cboService.Value = ""

txtQty.Value = ""

txtAvWt.Value = ""

txtCostValue = ""

txtRecQtyValue = ""

txtSDQtyValue = ""

TxtDate.SetFocus

End Sub

I expected that the four combo boxes would have the options above displayed, but when i run the form, the combo boxes are blank. I cannot see what mistake I must have made. I am using Excel for Mac is that makes any difference?

Thanks

[Alexph]

Its Ok, I have realised what i have done wrong now working Ok
Thanks