Hi,
I am trying to create an instruction within merged cells so the user understands what is required within it. Then once they select the merged cell it will disappear allowing them to type the answer. I have attached a workbook with the code I have used which works fine for an individual cell (E6) but does not work properly for merged cells (E5 and F5).
Thanks
Hi Cassie
Have alook at this link.
http://www.mrexcel.com/forum/excel-q...nge-macro.html
Good luck.
Tony
Hi and welcome to the forum.
You're discovering the delights of merging cells. The overwhelming view is avoid them like the plague unless absolutely necessary. They cause too many problems in all sorts of areas.
However your solution is simple
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Tony and Richard,
Thanks for the replys and both were very useful.
The coding is now working!
Is it possible to add coding to change the font to italics and colour to a light grey for the description and then once the cell is selected for it to change back to the normal cell colour and non italics.
Thanks
I think is easier to use Data Validation with input message and have cells empty to begin.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Glad to have helped and thanks for the Rep.
Actually I believe Izandol's data validation offering is to be preferred.
Thanks for the help and advice. I have managed to use data validation and it works well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks