Tab Selection Progmatically ?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Is it possible to select a tab progmatically, ie force a tab selection using software in the Ribbon Bar sample...

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
XpatTech Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 November 2007 Location: United Kingdom Status: Offline Points: 37	Post Options Post Reply Quote XpatTech Report Post Thanks(0) Quote Reply Topic: Tab Selection Progmatically ? Posted: 27 November 2007 at 5:06am
	Is it possible to select a tab progmatically, ie force a tab selection using software in the Ribbon Bar sample...

joeliner Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 09 June 2006 Status: Offline Points: 273	Post Options Post Reply Quote joeliner Report Post Thanks(0) Quote Reply Posted: 27 November 2007 at 5:48am
	Hi, Dim ribbon As RibbonBar Set ribbon = CommandBars.ActiveMenuBar ribbon.Tab(3).Selected = True

XpatTech Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 November 2007 Location: United Kingdom Status: Offline Points: 37	Post Options Post Reply Quote XpatTech Report Post Thanks(0) Quote Reply Posted: 27 November 2007 at 5:52am
	All i get is Runtime error '91': Object variable or With block variable not set.

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 27 November 2007 at 10:12am
	Hi, Have to work - its right code. May be you don't have 3 tabs.
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

XpatTech Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 November 2007 Location: United Kingdom Status: Offline Points: 37	Post Options Post Reply Quote XpatTech Report Post Thanks(0) Quote Reply Posted: 27 November 2007 at 10:38am
	Its the RibbonBar sample, it has more than 3. I may be getting the tabs I see mistaken for something else. Have a look at it, then laugh at me. If i have got it wrong can you explain what to do.

joeliner Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 09 June 2006 Status: Offline Points: 273	Post Options Post Reply Quote joeliner Report Post Thanks(0) Quote Reply Posted: 28 November 2007 at 10:25am
	Try check again. pls note, index 3 shows the fourth tab. ...also you can post the code yu use on ribbonsample.

XpatTech Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 November 2007 Location: United Kingdom Status: Offline Points: 37	Post Options Post Reply Quote XpatTech Report Post Thanks(0) Quote Reply Posted: 28 November 2007 at 10:51am
	No alterations have been made to the original code. Assume a button is used to select tab 2, how would that be coded ?

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 29 November 2007 at 1:38am
	ribbon.Tab(1).Selected = True
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

XpatTech Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 November 2007 Location: United Kingdom Status: Offline Points: 37	Post Options Post Reply Quote XpatTech Report Post Thanks(0) Quote Reply Posted: 29 November 2007 at 4:01am
	Thanks guys, not got a clue why it did not work at first (Probably stupid user) but I opened new ribbon sample and it worked first time. Again, thanks for helping a newbie.. I'll be back...............(Arnie I think ?)