I need to develop forms in excel for inputting info just as one would do in
access.
Can I use predevelped forms from access in excel? How do I change the record
source of the form to specific cells in excel?

You can create UserForms with all the control types you need, link these to
Excel cells, either by reference or through VBA coding.

Linking a control is achieved using the ControlSource property of the
Control, it is often better (for all but the simplest applications) to
read/assign control values to cells using vba, since this can provide
validation, formatting etc. Each control type has appropriate properties to
do this.

--
Cheers
Nigel



"Jay" wrote in message
...
I need to develop forms in excel for inputting info just as one would do
in
access.
Can I use predevelped forms from access in excel? How do I change the
record
source of the form to specific cells in excel?