The "dialog box" I want to load is a custom Userform I created with various
row-labels in a column (quantity, span, rise, width, etc..) and text boxes
next to each label. I guess you could say it is a combo box of text boxes
all used to receive values from the user. What I mean by constant is
definitely static. That is, for each Arch (which is what a column
represents), we must have certain values in order to calculate
quantities...an exact list of numbers must be entered for each arch. This
translates to an exact number of rows for each column. I want to vary the
number of columns to match how many arches need to be described.

So, my question is, can I create a userform where the number of columns
equals the value for "ArchNum"?

I have no code for the second dialog box because I do not know how to
complete it. I am trying to mess around with tabs or pages in a Userform but
do not know how to change the number of tabs/ pages from 2.


"JLGWhiz" wrote:

How do you load the other "dialog box" and is the "dialog box" a text box,
list box or combo box...? and if there is code associated with it, you should
probably post that also so we can understand what is meant by constant rows
of information. That is: Constant as in static, or constant as in
everchanging which would be dynamic.

"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?