Filling selected cells

  • Thread starter Thread starter Hobbit_Oz
  • Start date Start date
H

Hobbit_Oz

I wish to fill the activecell and the adjacent selected cells with th
data from a user form. Being new to visual basic I am not sure if o
how I can do this
 
Hobbit,

Do it before you exit the form, and use something like

with activecell
.value = textbox1.text
.offset(0,1).value = textbox2.text
.offset(0,2).value = textbox3.text
end with

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top