Sending textbox value to activecell

[ImranBhatti]

Hello

I am trying to send me.AddressBar.text to activecell of sheet10 using this

Please Login or Register  to view this content.

method range of object Global_failed error is poping up

Whats wrong here
ideas?

Best Regards
Imran Bhatti

[cytop]

The ActiveCell is a Range...

Please Login or Register  to view this content.

[ImranBhatti]

Working.But what is the logic?why not activecell.text as the cell is full of text?

[cytop]

Go and read up on the TEXT, VALUE and VALUE2 properties...

[Jan Mach]

Range.Value property (the default property for the range object) operates with variants, while Range.Text property with strings. Unfortunately, Range.Text is read-only hence cannot be used on the left side of '='.

The correct code is:

Please Login or Register  to view this content.

You don't need 'Me', userforms know their childs, i. e. controls. You'd need 'Me' only if you created the textbox in the runtime; you'd have to write Me!AddressBar (with '!') then.
Because there's a variant property ActiveCell.Value on the left side, I write a variant property on the right side, too.

Caution! If you want to place the content of AddressBar into another textbox, say, NameBar, you use the Text properties rather then the Value ones,

Please Login or Register  to view this content.

because textbox.Text property is read-and-write and (as a string-valued property) is faster then a variant-valued textbox.Value property.

In other words, find help pages for all objects you need to work with and read the help carefully. The click 'object members' in the help page bottom and learn all object's methods and properties; not only what they do but also what types of values they use (integers, longs, singles, doubles, strings, variants, dates, ranges, ...).
You get the help page when, in your code, you place cursor on the word you need a help to, and press F1.

[ImranBhatti]

Thanks both of you John ,cytop for helping me understand that property.