Autofill Vlookup/Formula to last row in multi range and option button

Greatly appreciate for helping me with below:

1. I have Vlookup and formula from Range "B1:AM1". How can I autofill those to the last row depends on data of column A:A (Exp: if the last data on column A:A is A599 so autofill all Vlookup/Formula from B1:AM1 to range "B599:AM599").

2. a_I have GroupBox (Car) includes: two Option Buttons (Yes & No).
b_CarUserForm includes: three labels (Model, Year, Insurance); three textBox for each label; two CommandButton (OK & Cancel)
When I click Yes (CarUserForm popup) let people enter info into three TextBox and hit OK (value appears on Range in order A1, A2, A3). If any TextBox info is missing so MsgBox "Please enter Model" or "Please enter Year" or "Please enter Insurance" popup (depends on which TextBox info is missing) and CarUserForm still open to let people re-enter info.
If people hit Cancel to Unload CarUserForm then Option Buttons automatic change form Yes to No.

Thank you very much for all your help
tt3

Hi AB33 & HSV,
Thank you very much for your quick help but please take a look at my files sample and show me the code.

Best regards,
tt3

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Or:

Please Login or Register  to view this content.

@ AB33

Hi,
I tried with your code but it didn't autofill to last row. Not sure what I did wrong.

Thank you for your help. Please look at sample file in the attached and help me out.

tt3

@ HSV

Hi Harry,
Thank you for your help but I don't know how to use your code because I'm a beginner. Can you look at the sample file in the attached and give me some code.

Regards,
tt3

I put some formulas in row 1 (B1 to AM1)
The most formulas don't work, but that's irrelevant.
Run code hsv()
Alt+F8 → Run.

Hi Harry,
That's awsome but please look at filesample in attached (this is difference) and advise with code how to run. Can you help me with other code (Car_OptionButton)

Regards,
tt3

Hi AB33,
That's working perfect with the filesample but please look at filesample in attached (this is difference) and advise. Can you help me with other code (Car_OptionButton)

Regards,
tt3

What result did you expect @tt3.

There must be a formula in range ("H18:AM18").

Try it once.
Ps.
The code is in the example.
Also the code below works if you will put de data from range B1:B7 in range A1:A7.

Please Login or Register  to view this content.

@tt3,

Please Login or Register  to view this content.

Clear Range("B1:B7"), and code hsvtwo() runs perfect too.

Please Login or Register  to view this content.

[QUOTE=HSV;2988670]@tt3,

Please Login or Register  to view this content.

Hi HSV/AB33,

The code is perfect and thanh you very much for all your help. How can I make it limit to 1000 rows because my worksheet only run up to rows 1000 then pop up a msgbox "You have reach over limit of 1000 line".

Regards,
tt3

@tt3,

Something.

Please Login or Register  to view this content.

The formulas are converted to values.

Please Login or Register  to view this content.

How you had it your self proposed?

Originally Posted by HSV

@tt3,

Something.

Please Login or Register  to view this content.

Hello tt3,

If you run the code, the formulas will be values.
You can't continue autofill to 2000 if there are no formulas in row 18.