View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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?