Short-cut key for Spacebar in VBA...

saurabh726

Well-known Member
Joined
Dec 13, 2003
Messages
891
Hi All,

I have a typical query...well like ~ = Enter sign in giving command in VBA... Similary i have a tickbox of which i dont know the shortcut key to give the command in VBA.

???= Spacebar....????

Can Anyone help me in this...

Saurabh...
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
not clear . will this help

in vba something like this

range("a10")="???" & " " & "???"
 

saurabh726

Well-known Member
Joined
Dec 13, 2003
Messages
891
Hi Venkat...

Thanx for your help..However im not at the workbook...

Im at internet explored and there is a list box which i can uncheck by pressing spacebar though i dont know what to write so that it unchecks tht list box by pressing spacebar...

And thts wht im looking for..
 

Kevlarhead

Board Regular
Joined
May 23, 2006
Messages
176
That's built in already. Use Tab and Shift-Tab to shift the focus around a form and space to perform an action on the control that has focus.

Or have I misunderstood?
 

saurabh726

Well-known Member
Joined
Dec 13, 2003
Messages
891
Hi Kevlar...

I am able to focus the tickbox on the internet page...However im not able to unclick it since the action is been done by pressing space bar button and i dont know wht to write in the macro so thtt it performs the desired action of clicking the spacebar button and unchecking the tickbox.

Saurabh..
 

Watch MrExcel Video

Forum statistics

Threads
1,114,406
Messages
5,547,759
Members
410,811
Latest member
adustin42
Top