M
mxp44
Hi all,
Using VBA, I'm trying to achieve the following:
1.1) In the first step, I'll let the user enter two informations into
the form that will appear in workbook he will work on:
- Name (Textbox1)
- First Name (Textbox2)
( I know how to make appear the form, this part is OK...)
1.2) At the same time, the user will have several other open workbooks,
each of them having the same structure ("Input" worksheet, etc...)
2) Then, when the user will click on "OK" button of the form, the macro
behind should do the following:
- go to the "input" sheet of every workbook open (included the workbook
with the form)
- consider only the range B5:C40 of these "input" sheets
- find the first line within this range that will have both columns (B
& C) blank/free (=> this can vary from workbook to workbook)
- paste Textbox1 and Textbox2 info (defined in step 1.1) into column B
and C respectively
- at the end, select the cell into column D (same line) of every
workbook, "input" worksheet...
The most difficult part for me is to determine, sheet after sheet,
first free line for the given B5:C40 range (let's assume that the range
will never be totally full)
Can you help with this?
Thanks a lot,
Mark
Using VBA, I'm trying to achieve the following:
1.1) In the first step, I'll let the user enter two informations into
the form that will appear in workbook he will work on:
- Name (Textbox1)
- First Name (Textbox2)
( I know how to make appear the form, this part is OK...)
1.2) At the same time, the user will have several other open workbooks,
each of them having the same structure ("Input" worksheet, etc...)
2) Then, when the user will click on "OK" button of the form, the macro
behind should do the following:
- go to the "input" sheet of every workbook open (included the workbook
with the form)
- consider only the range B5:C40 of these "input" sheets
- find the first line within this range that will have both columns (B
& C) blank/free (=> this can vary from workbook to workbook)
- paste Textbox1 and Textbox2 info (defined in step 1.1) into column B
and C respectively
- at the end, select the cell into column D (same line) of every
workbook, "input" worksheet...
The most difficult part for me is to determine, sheet after sheet,
first free line for the given B5:C40 range (let's assume that the range
will never be totally full)
Can you help with this?
Thanks a lot,
Mark