Code:
Sub OpenHarvestForm() '<-- sub name
Application.WindowState = xlMinimized '<-- minimzes the entire excel workbook
frmHarvest.Show '<-- makes userform visible
Application.WindowState = xlMaximized '<-- makes excel workbook full sized
ActiveWorkbook.Sheets("GrpRecords").Activate
'^^^^ "Activate" prepares sheet GrpRecords for receiving actions such as writing data to it
End Sub
What you need to do is right click the sheet tab / view code.
When the VBA editor window opens you want to right click on the icon FORM (see arrow)
Then View Code.
https://www.amazon.com/clouddrive/sh...hare_link_copy
The code displayed in the large window changes how the various controls on the form function.
If you just view the form itself (so it shows in the right hand window) you can edit the controls, labels and positioning of each.