The op admits he is learning VBA and is struggling. Perhaps if he posted the
code he has, we could help point the way around some common pitfalls with
VBA that a beginner could come up against.

Mike F
"Tom Ogilvy" wrote in message
...
I would shoot myself if I used activecell to write information from a
userform to a worksheet, for an application that is expected to write
25,000
lines. <g But maybe I assume too much.

--
Regards,
Tom Ogilvy




"Mike Fogleman" wrote in message
...
Tom, even if he Activated the hidden sheet, Activecell would still refer
to
the visible sheet. He would need to change some code to qualify the range
on
the hidden sheet.

Mike F
"Tom Ogilvy" wrote in message
...
If you just added a sheet, then made the data sheet hidden, you would
need
not additional code to manage the added blank sheet.

--
Regards,
Tom Ogilvy


"Duncan" wrote in message
oups.com...
Hello,

Does anyone know of a quick way to hide the sheet that the form is
submitting info to? I have experimented with worksheets.visible = true
but then i would need at least one sheet that is visible. my book
contains only one sheet and my form is referring to cells via
activecell.value = (fieldname) to submit the data upon clicking the
button but if i made another blank sheet so i could hide the proper
one
i would have to change my input coding. (or would I?)

i also tried with making the form massive but you can still drag it
out
of the way and also i would have to cater for differant screen
resolutions.

I'm not really good with vba macros (I'm really learning as i go
along)
and it has took a good two days solid of experimenting to arrive where
i am now (which should take a competent programmer about an hour!) so
does anyone know of a real simple solution that im too simple to know
about?!