Message 1 of 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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...
Wayne Helley
Inventor 2013 Certified Professional
Autodesk Inventor Professional 2023
Visual Studio 2022
Windows 10 Pro, 64-bit
Inventor 2013 Certified Professional
Autodesk Inventor Professional 2023
Visual Studio 2022
Windows 10 Pro, 64-bit
Solved! Go to Solution.