Template Wizard with Data Tracking

G

Guest

I would like to use the template wizard with data tracking. If I create a
form using the forms toolbar to create list boxes, option boxes etc. can I
have this data added to the linked database? Since the form controls are not
cells, is this possible? Would this involve a lot of code?
 
D

Debra Dalgleish

You can link the list boxes, etc. to worksheet cells (right-click the
listbox, choose Format Control, enter a cell reference in the Cell Link
box.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template wizard with data tracking problem 1
Template Wizard w/ Data Tracking add-in 1
Wizard with Data Tracking template wont work in 2007 2
Template Wizard with Data Tracking (wztemplt.xla) Path 2
Template Wizard with Data Tracking - Excel 2007 compatibility 2
how can i use template wizard with data tracking in excel 2007 1
Excel Template Wizard? 1
VBA - retrieve data on last create named range from previous inserted named range 0

Top