The approach your doing is probably your best bet until you become more familiar. so try this for now.
Put this code in your button's code. and this will automatcally bring up your dataform for all your input
Make sure you have headers on all your columns
Range("a1").Selec
ActiveSheet.ShowDataFor
----- Ciscolo Bandero wrote: ----
I'm rather new to Excel and know nothing about VBS. I was trying t
find a way to create a form so I could enter data onto a worksheet
Something along the lines of a button on the worksheet and that open
a form to enter data that is entered to the sheet after the entry i
complete
I've already tried using the Data|Forms option, even recorded a macr
that was actuated by a button placed on the worksheet
So my question is this. Considering my skills,
VB looks rathe
complicated. Is the feat mentioned above doable or should I look a
quite a bit of reading/research before attempting