VBA Timephased Macro

[Gaurav Wason]

All,

I am writing a macro to be used in resource usage view. If a user clicks in
timephased grid for an assigment. I need to know which month is he/she
selecting and uptdate that cell in timephased view. Any idea will be helpful.

 

[Barbara - Austria]

Hi Gaurav,

I have never found a possibilty to get selection information from usage
views. If someone else can tell, I will be happy to learn (and re-write a
few macros)!
As a workaround I use inputbox to get startdate and #columns or finishdate.

Regards
Barbara

 

[Gaurav Wason]

Thanks Barbara. Will keep you posted If I find something.
--
Please rate this post if it has helped

Thanks
Gaurav Wason
http://projectmadeeasy.com

 

[Rod Gill]

I don't know of any way to determine date from selected cell in time phased
view (yellow Area). ActiveCell is the closest but that only works in the
Table (white) area.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Thanks Barbara. Will keep you posted If I find something.
--
Please rate this post if it has helped

Thanks
Gaurav Wason
http://projectmadeeasy.com





__________ Information from ESET Smart Security, version of virus
signature database 5011 (20100408) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5011 (20100408) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gaurav Wason]

Thanks everyone. I will keep you guys updated if I find anything.
--
Please rate this post if it has helped

Thanks
Gaurav Wason
(e-mail address removed), PMP, MCITP roject Made Easy (Project Server Archive Tool)
and (Project Owner Tool)
http://projectmadeeasy.com

 

[Barbara - Austria]

Hi Gaurav,

don't waste too much time in searching. If Rod as VBA expert doesn't know
any way to get that done, I am quite sure that there isn't any.

Regards
Barbara

 

[Gaurav Wason]

Rod,

Is there a way to find which assignment (from white area) you are in?
--
Please rate this post if it has helped

Thanks
Gaurav Wason
(e-mail address removed), PMP, MCITP roject Made Easy (Project Server Archive Tool)
and (Project Owner Tool)
http://projectmadeeasy.com