Follow up question. If I it is not possible to create a box with number of
columns dependent on the previous entry of a dialog box then can I change the
number of tabs on a custom dialog box to match this value?

"cparkerUA" wrote:

I am trying to create a custom dialog box where the number of columns is
dependant on a varable defined in the previous dialog box. Here is as much
code as I have.

Dim ArchNum

Sub BidSheet()
ArchNum = InputBox("Enter number of Arches", Arches)

End Sub

I know this code sets 'ArchNum' to the specified number entered however I do
not know how to translate this value into the next dialog box's format. I
want the variable "ArchNum" to equal the number of columns in a custom dialog
box that displays constant rows of information. Is it possible to alter a
custom dialog box in this manner?