how can I use access forms in excel2003
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?
|