BigWill5112
asked on
vba screentip not working
no master at vba but feel i'm getting better. See the below screenshot. after I hit the spacebar after the "d" in find its giving me a screentip for the offset method not the find method. Why is it doing this?
Book1.xlsx
Book1.xlsx
also, try
firstrow.Offset(0, 2).value = shtNames.Range("a1").Entir
firstrow.Offset(0, 2).value = shtNames.Range("a1").Entir
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
:)
So simply adding the open parenthesis (bracket) "(" to the line "resolved" the issue?
Yes, by all means close the question. That is indeed normal functionality!
Glad you learned a few things along the way though.
Good luck with the rest of your project.
So simply adding the open parenthesis (bracket) "(" to the line "resolved" the issue?
Yes, by all means close the question. That is indeed normal functionality!
Glad you learned a few things along the way though.
Good luck with the rest of your project.
ASKER
because it is the only thing that works.
firstrow.Offset(0, 2) = shtNames.Range("a1").Entir
The IntelliSense feature is probably getting confused due to the structure of the statement you are using, or there is an issue with aligning the caret (text insert) position in the code module pane.
Moving or re-sizing the window may well resolve the issue. Alternatively, adding spaces between your other code statements may work.
However, restructing the code statement into two distinct statments may resolve the issue too.
Try using a Range object for the result of the Find statement:
Dim objRange As Range
.
.
.
Set objRange = shtNames.Range("a1").Entir
Then...
firstrow.Offset(0, 2) = objRange
BFN,
fp.