J
John Murray
G'day All,
i'm wondering if I am approaching this problem the right way
and would appreciate some assistance.
I'm assisting a mechanical engineer mate of mine with
converting all of his excel sheets to vba so he can clean them all up
and learn vba as well. After a couple of years away from it I am
finding myself a bit rusty.
One problem I'm having difficulty with is as follows. We have
converted a spreadsheet to vba and it works fine. It has a userform
for data entry and a few basic controls to input values. We have 4
text boxes for data entry and they have a limited range of values.
What the inputs are are as follows
Shaft Poisons ratio
Hub Poisons ratio
Shaft modulus
Hub modulus
These are related properties of varous grades of steel. Instead of
repeatedly entering them into the form, I have attempted to use either
a combo box or list form, select one grade and populate the text boxes
with the values selected in the list/combo box. About 12 rows by 5
columns. The first column is the grade of the steel and I wish to use
the other 4 columns to fill in the values.. I am able to fill the
list/combox controls with the data BUT, a) I am unable to name the
column headers in either control. I am sure that it is possible. Is
this so? I am able to turn the headers on and off. but they are blank.
Am I clear there? I want the header row so that it is obvious what the
values are in the columns below. Otherwise they are just meaningless
to someone who wouldn't be able to confirm the numbers are correct.
Is either of these controls the way to go or is it better to use a
different type of control. We don't want to use worksheets to store
the information.
Cheers
John Murray
i'm wondering if I am approaching this problem the right way
and would appreciate some assistance.
I'm assisting a mechanical engineer mate of mine with
converting all of his excel sheets to vba so he can clean them all up
and learn vba as well. After a couple of years away from it I am
finding myself a bit rusty.
One problem I'm having difficulty with is as follows. We have
converted a spreadsheet to vba and it works fine. It has a userform
for data entry and a few basic controls to input values. We have 4
text boxes for data entry and they have a limited range of values.
What the inputs are are as follows
Shaft Poisons ratio
Hub Poisons ratio
Shaft modulus
Hub modulus
These are related properties of varous grades of steel. Instead of
repeatedly entering them into the form, I have attempted to use either
a combo box or list form, select one grade and populate the text boxes
with the values selected in the list/combo box. About 12 rows by 5
columns. The first column is the grade of the steel and I wish to use
the other 4 columns to fill in the values.. I am able to fill the
list/combox controls with the data BUT, a) I am unable to name the
column headers in either control. I am sure that it is possible. Is
this so? I am able to turn the headers on and off. but they are blank.
Am I clear there? I want the header row so that it is obvious what the
values are in the columns below. Otherwise they are just meaningless
to someone who wouldn't be able to confirm the numbers are correct.
Is either of these controls the way to go or is it better to use a
different type of control. We don't want to use worksheets to store
the information.
Cheers
John Murray