Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

ResolvedVersion 2003

Wed 29 Oct 2008, 15:31 Delegate Dean said...

Dean has attended:
Excel VBA Intro Intermediate course

VBA

How do you get bookmarks to work if you are linked to a SQL database and the bookmarks are the coloumn headings in the database

Mon 10 Nov 2008, 17:16 Trainer Jacob said...

RE: VBA

Hi Dean

Thanks for your post and by what you have outlined we will need to have some detail from you including, where relevant, sample files.

We will then be able to confirm if we can help, the scope of work involved and any related costs.

Kind regards

Jacob

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Adding date and time