A pointer or two needed using userform
 

first let me say I almost never use excel,now I have a worksheet with
7500 lines and about 12 cols that I have to go through and edit parts
of. I have to change 6 cols in a selected range by dividing by a
number,add some data to another couple of cols,and some text to
another couple.I made a macro with Inputboxes in which I select the
range,the math factor, enter the new data and text.I have 6
inputboxes,it seemed I could use a form and textboxes,do all input at
once,but I can't seen to get it to work.the form shows but the input
is not being processed. the same cols always get the same processing,
col D to J is divided by whatever is needed for the selected range,col
K is always a new number added,col A and C is alway new text,not the
same text.Current Macro is select range D? : J?,enter math number,
select K range K?,enter K number,etc.
row range is the same across all required cols.I might select 1 row
or 200 rows at a time.
can anybody show me how to make a form to do this in one step
rather than six or seven,
thanks
J

A pointer or two needed using userform
 

Jim,

<<I have to change 6 cols in a selected range by dividing by a number

Simply put the divisor in a different cell, and then go copy | paste special
| operation divide

<<add some data to another couple of cols

Similar to above, except operation add

<<and some text to another couple

Use the concatentation feature or use "&". Create a new column if required
to put your results in. For example, if you want to combine Col A with " I
am here", then put " I am here" in Z1,
and then put in Col B =a1&z1. Once you have completed Col B, you can copy
and paste the values into Col A if that is your desire.

Unless you have a strong urge to use VBA, you might be able to do a quick
couple of copy and pastes, and then you're done.

Best regards,
Kevin




"Jim" wrote in message
om...
first let me say I almost never use excel,now I have a worksheet with
7500 lines and about 12 cols that I have to go through and edit parts
of. I have to change 6 cols in a selected range by dividing by a
number,add some data to another couple of cols,and some text to
another couple.I made a macro with Inputboxes in which I select the
range,the math factor, enter the new data and text.I have 6
inputboxes,it seemed I could use a form and textboxes,do all input at
once,but I can't seen to get it to work.the form shows but the input
is not being processed. the same cols always get the same processing,
col D to J is divided by whatever is needed for the selected range,col
K is always a new number added,col A and C is alway new text,not the
same text.Current Macro is select range D? : J?,enter math number,
select K range K?,enter K number,etc.
row range is the same across all required cols.I might select 1 row
or 200 rows at a time.
can anybody show me how to make a form to do this in one step
rather than six or seven,
thanks
J