Filling selected cells
 

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

--
Message posted from http://www.ExcelForum.com

Filling selected cells
 

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)

"Hobbit_Oz " wrote in message
...
I wish to fill the activecell and the adjacent selected cells with the
data from a user form. Being new to visual basic I am not sure if or
how I can do this.


---
Message posted from http://www.ExcelForum.com/