Help me add a Fact of the Day to a User From!

[waynehelley]

I know what I am doing with the logic side of it...

Dim row As Integer
GoExcel.Open("C:\Work\Designs\Templates\2013\Inventor Templates\Metric\UK iLogic Configurators\MCC Tier Configurator Data.xlsx", "Facts")

i=0
For row = 1 To 1000
'Exits the FOR function when reaching the end of the list
If (GoExcel.CellValue("A" & row) = "") Then
Exit For
End If
i=i+1

Next

RandomRow=CInt(Int((i * Rnd()) + 1))

RandomFact=GoExcel.CellValue("A"&RandomRow)

Facts=RandomFact

I'm having the problem with formatting my user form.  I have added the parameter to the user form but it pushes all my drop down boxes to the righ-hand side

When it should look more like this...

[Anonymous]

I think it has something to do with the anchor option...

[waynehelley · Accepted solution]

I managed to find a work around by using a multi-row parameter instead of a header...