Dashboard

Good 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?

I can't…

Hi
what's wrong ? B1 is contained in A1. Do you mean B1 and nothing else ( the A1=B1) ?

Hi,
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…

It 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?

Hi,

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…

[…]


... because there isn't any. The only option is what you've already found.

For 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?