BikkeReplied to the thread Disable copy and paste in three ways Excel 2007.PostGood evening
The post appears as solved, but it's not true, because I haven't had any answers with the solution, nor can I find anywhere the solution to my problem.
The post automatically becomes solved after some time if there are no replies?
PecoflyerReplied to the thread Formula to find and match an exact word in a cell.PostHi
what's wrong ? B1 is contained in A1. Do you mean B1 and nothing else ( the A1=B1) ?
sabarsiraitPosted the thread Formula to find and match an exact word in a cell.ThreadHi,
I need help to compare an EXACT WORD in a cell ("B1") whether is available in another cell (A1). I use this formula "=ISNUMBER(SEARCH(B1,A1))" in comparing Cell B2 and A2, but it gives me result as "TRUE", whilst it should be "FALSE". Can someone…
i would say that unload/show would be the better solution.
now it works good that i write my reason in the textbox, say ok and it writes in the excel. but if the userform loads again it is the allready filled.
so it would be good to unload it and show it…
BisonPupIt is possible to do just about anything - but figuring the best way to do it can be a problem.
Take my example of using vbNullString instead of "" (An empty string) - in general, it is preferable to use vbNullString rather than an empty string (they are…
if i write the vbNullString i get an error from "cell.value = TextBox1.Text - maybe because i would write the reason from the textbox in a field and not to empty before close.
is it not possible to empty the textbox always before opening?
iqballudPosted the thread Label Click then Caption Update on Userform2.Label1.ThreadHi,
I have two UF, UserForm1 and UserForm2.
UserForm1 content Multipage1 with 15 pages. There is Label on each pages. If this Label.Click then the (Name) of Page in Multipage1 will print/record to the Label1.Caption in UserForm2.
Then In UserForm2 the next…
iqballudReacted with to cytop’s post in the thread UserForm Title Bar font color change.Reaction (Post)[…]
... because there isn't any. The only option is what you've already found.
BisonPupFor example, where-ever you hide the userform
(Code, 4 lines)
You already do this, using ="" (vbNullstring is preferable) in the Initialize event but that may have been after my message earlier.
i understand what do you mean - but how do i do that?