Short-cut key for Spacebar in VBA...

[saurabh726]

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...

 

[venkat1926]

not clear . will this help

in vba something like this

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

 

[saurabh726]

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]

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]

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..