Use VBA to fill in formulas in Cells

  • Thread starter Thread starter NetWave128
  • Start date Start date
N

NetWave128

I have a userform that has a selection method... I would like to fill
range of cells with a different formula depending on which cmd butto
is pressed in the form.

The Formula is a lookup and it is the same it just refers to differen
sheets based on the user input...

Thank You
 
Selection.Formula = "=VLOOKUP(A1, $B$1:$C$1000, 2, FALSE)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Autofill a dynamic range with a formula. 1
Cell Address & VLOOKUP in VBA 4
Fill down used ranges in several sheets 2
Filling a cell with formula only if cell in the column to the left isfilled 3
HELP!!! I can't set formula to cell 1
VBA code to Fill Down in a filtered list only to visible cells. 1
Array VLOOKUP lookup_Value does not increment 3

Back
Top