Add a background Word to the Excel cell

Source: Internet
Author: User
Tags range

  Add a background word to the Excel cell? 50 sometimes, to cope with people who don't use Excel, or to fill out a form with a description of what should be done here, the background text automatically disappears when the user double-clicks the cell for editing.
      should Excel be able to add a field name or some suggestive word in a cell to meet the above requirements? Data availability is not good! I need to be always shown when double click when the text disappears!
      Issues added:
      
       Just like this hint, when I want to enter text after the birth date, double-click the table,  1985-12-25 These fields will automatically disappear
    Data menu-effectivity
       If you can limit the range of input, prompt for input, prompts for errors or warning reminders! For example:

No direct shading is displayed!

Do not understand why you want to do so, think is the operating habits to make adjustments, in the cell input content, why must first double click?
Only the original cell has content, you need to modify it before you need to double-click. Use effectiveness, the ideal.
Set the text and yellow background on the B8 (you're like B8) and choose "Tools"-----"Macros"----"VB Editor" or ALT+F11,
In the VB Editor, first double-click Sheet1 (Sheet1) on the left window, and then copy the following code to the right, OK
-----------------
Private Sub Worksheet_beforedoubleclick (ByVal Target as Range, Cancel as Boolean)
If not Intersect ([B8], Target) are nothing Then
Selection.clear
End If
End Sub
-----------------------

Your code just defines the color and text that are automatically hidden after you double-click a cell but the colors and text don't appear again after the cursor leaves the cell

Just add this section to the back of the Code,
Private Sub Worksheet_selectionchange (ByVal Target as Range)
If Range ("B8") = "" Then
Range ("B8"). Select
ACTIVECELL.FORMULAR1C1 = "as 1985-12-25"
Selection.Interior.ColorIndex = 6
End If
End Sub
Again, if I change cell B8 to ask B89 (8th 9), How should I modify the code? Please enlighten me, I will add points,

Change the selection.clear in the first piece of code to the following:
Range ("B8"). Select
Selection.clearcontents
Selection.Interior.ColorIndex = Xlnone

In this very your answer. Your professional knowledge makes me admire!

You're welcome, I'm halfway decent's wild monk, too. Learn together
To achieve this effect, I can think of two ways to achieve this:
(1) Use the above mentioned macros to achieve.
(2) using the background to achieve. When this background is implemented, there is a certain amount of skill.

I know it can be implemented with macros, but I don't have a cold on VBA programming. I would like to ask the background is how to achieve, if you can solve a certain bonus points.

1, make a background picture, and this cell is almost large, there is this text. In fact, this picture, you can use Excel to do, very simple, afraid you have to ask me again. Alas. I'm bored these days.
2, insert the picture into the background.
3, all cell background color set to white. To enter the text where you want the border line will be bordered.
4, this cell, set to colorless.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.