I have a dialog, LatLong Wizard. Among various boxes is a ListBox, called LatDirBox which has two items: N and S. The Selection is 0, for N. We are collecting ship data and most of our ships are located in the Northern Hemisphere, but we are now working on some ships that are spending much of their time in the Southern hemisphere. It’s not practical to have the users change the LatLong Wizard itself. Our spreadsheets have a Setup Page which allows the user to change various parameters depending on the circumstances at the time. We would like to be able to be able to change the default 0 for the selection to be 1 for South simply by changing a variable on the Setup Page, which is easy for the users.
We have been using the various dialogs for about three years, and we have code for our Event Wizard to dynamically change a subtype depending on the type of event selected by the user, so we are familiar with coding for these dialogs.
I’m aiming for macro code that will set the Selection so it will show S when the dialog is opened. I was aiming for something like:
ArgOut = Dlg.Execute()
Selection = Dlg.getControl(“SelectionBox”)
Selection.Text = “1”
but, needless to say, that doesn’t work.