VB Help for Absolute Beginner

[Danny Sowden]

Please can someone help me.

I want a message box to pop up when a user clicks in a
cell in a table. Firstly what code do i need for a message
box and secondly how do i assign it to on entry of a table
cell?

Many thanks in advance

Danny.

 

[Harold Kless[MSFT}]

Hi Danny,
There are no events for clicking in a table. One possible solution would be
to have formfields in the table cells.
You can configure a Entry or Exit event to fire a macro.
So you could have this macro fire on Entry:
Sub ShowInfo()
Msgbox "Display Information"
End Sub


Harold Kless, MCSD
Support Professional
Microsoft Technical Support for Business Applications
(e-mail address removed)

--


This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

 

[Danny Sowden]

Thanks for this. It was just what i needed.

Danny.

 

[Cindy Meister -WordMVP-]

Hi Harold,

There are no events for clicking in a table.

Actually, there is, in a round-about way. Window
SelectionChange will fire.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail