How do I use send keys to a textbox in vba?

Question

1.00/5 (1 vote)

See more:

hi,

I am automating the webpage. While updating the textbox some key shold be pressed in that textbox. But I am coping values directly tin that textbox through code in vba. So values are note getting updated.

I have tried sendkeys. But its not working. giving error. code is as folows

iItems.SendKeys "{L}"

Error : Object does not have this property or method.
Please suggest me some solution.

thank you

Posted 6-Nov-15 1:05am

Member 12119299

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2015-11-06T01:52:00

Solution 1

Whatever that iItems object is it doesn't have a SendKeys method so you're getting that error.

SendKeys is a stand-alone function. You just remove the iItems. part and you won't get that error any more.

But, SendKeys is notoriously unreliable. You have no direct control over which control gets those keys. Even the user clicking on something else (the most common problem!) while your code is running will screw up and send your keys to whatever they clicked on. You cannot control this.

Posted 6-Nov-15 1:52am

Dave Kreskowiak

Comments

Member 12119299 6-Nov-15 8:41am

I want to press enter key in a textbox through code. How can be on that?

Sergey Alexandrovich Kryukov 6-Nov-15 8:43am

It you think that you want it, it does not mean that you really want it. Just insert new line in text.
—SA

Dave Kreskowiak 6-Nov-15 10:04am

Why?

Sergey Alexandrovich Kryukov 6-Nov-15 8:42am

5ed. You are right. It's hard to imagine any use of SendKeys, only abuse. Some use it to mimic input just because they don't know who to change some UI state programmatically; and for anything serious (such as keyboard macro) this thing is totally unsuitable.
—SA

Maciej Los 6-Nov-15 14:19pm

5ed!