Form activation from column selection

[sucharith]

Hi,

I need to activate a user form when a custom task field get focus. Is
there any such event, or can it be done otherwise.

I have tried using teh Project_change event and checked teh active
cell name and triggered it, but this only works if there has been a
change in the data.

Please suggest sny workarounds.

Thanks a lot

 

[Rod Gill]

Hi,

There isn't a click (or double-click) event in Project for a cell. You need
to create a macro that users can run by clicking an icon on the toolbar, or
have users enter data with a userform you create in VBA.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[sucharith]

Thanks a lot for the prompt reply!

So I hit a solid wall, looks like I will have to use some hot key or
icon for the macro to be activated.

Bye