Sendkeys - Userform

[CobraLAD]

How do I use sendkeys with a commandbutton on a userform

[davesexcel]

Hi,
Depending on what you want, this will open your combobox

Please Login or Register  to view this content.

[Andy Pope]

Setting a Buttons value to True will trigger the click event.

When do you think you need sendkeys?

[CobraLAD]

It must sendkey to sheet. I only want to use up or down

The sheet will be locked accept

J6:J17
J22:J33
S6:S17
S22:S33

so from J17, I want to go to J22 and down to J33 and from J33 to S6, and down to s17 and from S17 to s22 and down to S33 and then to J6 again

it works 100% if commandbuuton on sheet is used

[Andy Pope]

If you just want to make a cell active you can select it but normally that is not necessary.

This code in your userform code module defines the range you can move in and move through it by clicking the button.

Please Login or Register  to view this content.