J
Jim
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
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