getting "invalid qualifier" error while using " .text"

**joy3939** · 10-26-2014, 01:47 PM

Hi all,

I am very new to vba coding. I am trying to use the .text property but, getting an "invalid qualifier" error message while running the code. Pls guide me as to where i am making a mistake. Here is the code...

Please Login or Register  to view this content.

Thanks in advance.

**Norie** · 10-26-2014, 01:52 PM

userpass is a string, it has no properties.

Try removing .Text.

**mikerickson** · 10-26-2014, 01:55 PM

.Text is a property of some Excel objects.

Your userpass is a string variable, not an object. Strings are not objects, and have no properties.

Ranges are objects that have both a .Text and a .Value property.
.Value is a read/write property of a Range object, .Text is read-only for Ranges. (It is read-only for a Range object, for other objects (like TextBox objects) it is a read/write property)
(See the Object Browser in the VB Editor to see all the Excel objects and their properties and methods)

Please Login or Register  to view this content.

**joy3939** · 10-26-2014, 02:41 PM

Thanks for the replies..

getting "invalid qualifier" error while using " .text"

LinkBack

Thread Tools

Rate This Thread

Display

getting "invalid qualifier" error while using " .text"

Re: getting "invalid qualifier" error while using " .text"

Re: getting "invalid qualifier" error while using " .text"

Re: getting "invalid qualifier" error while using " .text"

Thread Information

Users Browsing this Thread

Similar Threads

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

[SOLVED] Help with "Invalid Qualifier" Error

[SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row

what does "Compile Error : Invalid Qualifier" mean?

Compiler says "Invalid qualifier" when using Application object

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions