Disapearing text.

[wendya]

Hi All,

I have followed the instructions in this post below, to allow for disappearing in cell instructions and I cannot get it to work on a merged cell. (I can get this to work on 1 cell that is not merged) I get an error type mismatch on row "ElseIf .Value <> sPrompt Then". It is just a string input.

Also, I have quite a few cells that I want in cell instructions for and I cannot seem to get the code to work using multiple merged cells. I just repeated the same code with a different range and it did not work. Sorry I am new to this!

http://www.excelforum.com/excel-prog...tructions.html

Here is the code on my worksheet below:

Please Login or Register  to view this content.

[TMS]

.Value1 is not valid. It does not exist. Put Option Explicit at the top of the module and compile the project.


Regards, TMS

[wendya]

Thank you TMS, I had seen my error on this after I posted, but it is .Value in my code and I still get the type mismatch with Option Explicit

Please Login or Register  to view this content.

If I Unmerge the cell, I do not get the "type mismatch" error anymore.. Is there something I have to do for a merged cell?

[wendya]

Also, to make this work on more than one cell how would I do that? For example, I want range C14:E14 to Say "Please type the request Date" but I want C15:E15 to say "Please type the description"?

Thanks!!

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[wendya]

Thank you very much TMS! This was what I needed! In order to not get the mismatch error, I unmerged the cells and will just use single cells for this. Thanks again!

[TMS]

You're welcome. Thanks for the rep.

Sorry. completely missed the Merged Cell bit. If you have merged cells, the cell count for the Target range will be more than one (1). If you tried to exclude Target.Cells.Count > 1, you would, effectively, ignore changes in the Merged cells. But, if you don't, you can't say IsEmpty(.Value) because you are not looking at one cell, you are looking at a range. That's why you get the Mismatch.





If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[wendya]

Ok, that makes sense! For this purpose, I can remove the merged cells. Thanks again for your quick and awesome help!

[TMS]

You're welcome.