Please help

  • Thread starter Thread starter Vincent Chua
  • Start date Start date
V

Vincent Chua

Hi,

1) Is there any way to hide the combo box if I wanted to
print? I only want the value to be printed.
2) Is there a way to select date in Excel worksheet?
 
1) (Assumed combo box was made from Forms toolbar) Just select the combo box
(right-click it), select Format control, and in the Properties tab,
de-select Print Object. In code, just select your combo box, then use line
like: Selection.PrintObject = False to set this to not print.

2) Don't know what you need here....

MRO
 
1) Allow input of date. I'm designing my invoice and I wish to be able
to click on the date box and a mini calendar of the month popup for me
to choose which date. Default will be today's date.

2) Is there a way to link outlook contact list with excel? Most of my
customer details are in outlook address book. If I'm going to invoice
one of the customer, I just need to click the invoice to field and link
to the contact list for me to select which customer. After selecting,
the name, company name, address, phone and fax should able on the
invoice.

Thanks for your kind help.
 
Back
Top