Hi, I hope someone can help me with my question. I'm afraid that I am no VBA expert but I do have some programming knowledge. I would like a VBA macro in Project 2007 that when it runs it can find out the column and row headers and either store them to a pair of variables or pop a message box with this info in. As an example if I was in the second column and second row of the opening task info project table I would like to be able to retrieve the fact that the column header is "Task Name" and the row header is "2". I have searched through various posts and tried to figure out how to do this on my own but have had no luck so far. It may sound like a strange request but as a bit of background it is for a visually impaired computer user. Thanks in advance for any help or guidance that you can offer me. Spen
Hi, Application.activecell.fieldname Application.activecell.task.id Hope this helps, -- Jan De Messemaeker Microsoft Project Most Valuable Professional +32 495 300 620 For availability check: http://users.online.be/prom-ade/Calendar.pdf "spencer" wrote in message news:012CE7EE-A20D-4F19-B9F7-A680A02D9731@microsoft.com... > Hi, > > I hope someone can help me with my question. I'm afraid that I am no VBA > expert but I do have some programming knowledge. > > I would like a VBA macro in Project 2007 that when it runs it can find out > the column and row headers and either store them to a pair of variables or > pop a message box with this info in. As an example if I was in the second > column and second row of the opening task info project table I would like > to > be able to retrieve the fact that the column header is "Task Name" and the > row header is "2". I have searched through various posts and tried to > figure > out how to do this on my own but have had no luck so far. > > It may sound like a strange request but as a bit of background it is for a > visually impaired computer user. > > Thanks in advance for any help or guidance that you can offer me. > > Spen
That's exactly what I wanted. Thank you very much for your prompt and extremely helpful response Spencer "Jan De Messemaeker" wrote: > > Hi, > > Application.activecell.fieldname > Application.activecell.task.id > > Hope this helps, > -- > Jan De Messemaeker > Microsoft Project Most Valuable Professional > +32 495 300 620 > For availability check: > http://users.online.be/prom-ade/Calendar.pdf > "spencer" wrote in message > news:012CE7EE-A20D-4F19-B9F7-A680A02D9731@microsoft.com... > > Hi, > > > > I hope someone can help me with my question. I'm afraid that I am no VBA > > expert but I do have some programming knowledge. > > > > I would like a VBA macro in Project 2007 that when it runs it can find out > > the column and row headers and either store them to a pair of variables or > > pop a message box with this info in. As an example if I was in the second > > column and second row of the opening task info project table I would like > > to > > be able to retrieve the fact that the column header is "Task Name" and the > > row header is "2". I have searched through various posts and tried to > > figure > > out how to do this on my own but have had no luck so far. > > > > It may sound like a strange request but as a bit of background it is for a > > visually impaired computer user. > > > > Thanks in advance for any help or guidance that you can offer me. > > > > Spen > > >
