Background Text To Be Overwritten

Feb 20, 2009

I am trying to create a user form, and need to admit at this point that unfortunately I have no knowledge of VBA - bog standard excel formulae are what I know!

I am trying to create a section for people to enter an address, and in itself this is quite straightforward, but I want to be able to enter faint text in the cells as an information instruction that will disappear as someone starts to type in that cell. Can anyone help with a method that would work within Excel versions 2000, 2003 & 2007? (I realise that I could insert a comment, but it's not an obvious instruction, and given the Excel knowledge of a lot of people who will be using this form, it would be completely overlooked!)

View 9 Replies


ADVERTISEMENT

How To Make Text Background On Editable Cells And Print Without Text Background

Oct 28, 2013

How to make a text background on editable cells and print without text background?

View 4 Replies View Related

Why Are Formulas Automatically Overwritten By Result

Apr 7, 2004

When I enter a formula into a cell, for instance; (d27*d28/144)*d23, and then enter a number into cell d23, the formula gets replaced by the value of the result automatically.

I've searched the help files and found no setting that does this. It reminds me of an old question I've had lingering since I've used excel and that is why sometimes when you enter a math calculation, for intance; =25/5, the number 5 is entered into the cell instead of the formula.

After I posted the above, the problem magically went away until.....

This is boggling my mind. The problem is back.

The wierd thing is I copy a known good formula to one of these cells, for a split second you can see the formula in the formula window and then it gets changed automatically to the result of the formula. Formula is gone!

Then I tried this:

I set security to high (I had it on Low) and of course my macros would not run, but this did not clear up the problem. However when I set security back to low, it now seems to be working good. I am scepticle (sp.?) though because the problem is very random.

Could I have a virus?

View 9 Replies View Related

Color Cell If Formula Overwritten

Oct 31, 2006

Is there a way to embolden/highlight/colour, etc. a cell and its contents when a formula in that cell has been overwritten with text?

View 2 Replies View Related

Conditional Formatting: Show If A Formula Has Been Overwritten

Apr 1, 2009

There is a clever piece of conditional formatting designed to show if a formula has been overwritten. It works by creating a range called (say) CellHasFormula and then entering =GET.CELLl(48,Indirect("rc",false)) in the reference box. In the cell you wish to conditionally format you enter =CellHasFormula. If the formula in that cell is overwritten, then the conditional formatting is displayed.

View 4 Replies View Related

Copy And Paste - Existing Data Overwritten

Nov 28, 2011

I have 2 opened workbooks. Call them BookCopy.xls and BookPaste.xls.

In BookCopy.xls I have filtered data which I want to copy ("shtCopy") and insert into a particular row in sheet ("shtPaste") in BookPaste.xls.

"shtPaste" already has data in it. Hence when I paste the data in, I don't want the existing data to be overwritten.

View 9 Replies View Related

Text Over Background Image/Picture

Aug 27, 2006

I want to add an image to a sheet. The image is to print but I want the data from that sheet to go over the top. I can't seem to get the image behind my data.

View 6 Replies View Related

Normalize Data Across Duplicates But Keep Field Containing Overwritten Values?

Mar 31, 2013

I have a file of company name exactly duplicated. Within each duplicate set of rows each row can have a different account code (number).

I need to normalise all rows to one account code (any one will do - I can actually do this bit using some commercial software so this bit can be skipped as part of this thread) but also keep every variation/different account code in an 'audit trail' field for each row.

The attached sample file shows the input and desired output i would like.

View 1 Replies View Related

Changing Textbox Background Based On Other Cell Text

Jul 15, 2014

I wish for a text box (drawn Text Box, from the "Shapes" tab) to conditionally change its background color based on whether a cell in a different sheet says "Online" - in which case it should be green, or "Offline" - in which case it should be red. So far, the code that I have that doesnt work at all, which I'm not even sure where to place (I tried in the Workbook - Open?), is the following:

[Code] .....

I also need to do this for a total of 9 Text Boxes, if that changes anything.

View 6 Replies View Related

Conditional Format - Hiding Text With Shady Background

Apr 18, 2007

I'm attempting to use Conditional Formatting to hide text where the background is shaded. When the background is white, I can just set the text to white and it is invisible - no problem. However, when the background is set to anything else, and I set the text to the same color as the background, Excel LIES to me. It pretends that the text is invisible, but it still shows up in Print Preview and when it's actually printed. The Custom Format ;;; doesn't help me, because I need the invisibilization only under certain funky conditions.

View 5 Replies View Related

B1:B6 Background To Change To Green, And Text To Stay Black

Oct 4, 2009

I have a table with a range A1:C6

If B1 is “hello” I want B1:B6 background to change to green, and text to stay black
But if B3 is “goodbye” I want this to override the above and make B1:B6 background white and text colour of B1:B2 and B4:B6 white (so the text in these cells seems to disappear).

View 9 Replies View Related

Macro To Change Background Color And Text Of Certain Cells On Mouseclick

Mar 15, 2013

creating a macro. I would like the background color of certain cells under column A (cells 12:25, 27:32, 34:38, 40:45, 47:51, 53:61, 63:70, 72:79, 81:88, 90:92) to change to the color green and display the text "Complete" on mouseclick.

Before the cell is clicked, it would be the color red, with no text. (I'm not sure if you need to know that).

Next, I would need a macro that resets everything back to red. I hope this macro could be assigned to a form button.

View 1 Replies View Related

VBA To Change Background Colour In Free Form Depending On Text In Cells?

Apr 3, 2014

I have a spreadsheet with several freeforms. I would like them to change backgroundcolour, if the content in a cell is equal to another cell.

Basically I would like my shape "Freeform1" to change backgroundcolour to RGB (0, 180, 0) if Sheet1.Range ("A1") = Sheet2.Range("D3").

If it's not the same content in both cells, I would like the freeform to remain unchanged, that's RGB (79, 129, 189).

This should happend automaticly, so I don't have to click the shape to make it happen.

View 5 Replies View Related

Changing The Background Of A Range Based On Text In The Range

Oct 20, 2008

I have been tasked with creating a scheduling system for my work. There are three groups of shifts that can be selected, Opens, Swings, and Closes. I have been asked to make the cells turn red if a user selects a sequence of shifts. We are trying to avoid having a person working three scenarios:

Close>Swing>Open
Close>Off>Open
Close>Open

If they select the shift that meet this scenario, then I need the cells to turn red. The complete list of shifts are on the "Data" tab and the the three scenarios have been inputted into the "Jan" tab in E13:G15.

I am using the code below to change the background of the cells in my worksheet based on what is in the cell. How can I modify it to accomplish the changes below and meet the criteria above?

View 12 Replies View Related

Set Background In Cell Depending On Another Cell's Background

Jan 15, 2009

In a range of cells (A1..d8) which have background set with multiple colors. Is it possible to set another range of cells (H1..K8) whith the same backgrounds as the other range and so that if one cells background changes the cell in the second range whill also change to that new color?

View 11 Replies View Related

Background Colour

Dec 18, 2009

I have to codes which work

View 3 Replies View Related

Graph Background

Jul 6, 2006

I'm working on a interfacing program between delphi-excel to manipulate data (from delphi tables) and create a graph in excel. The program is almost done, but I'm having problems with the background and foreground color of the graphs, which don't change.

View 9 Replies View Related

Set Desktop Background

Mar 28, 2008

Im designing a desktop background for my office, and want to roll it out once complete. Rather than trying to email the image out and get people to do it manually, is there anything in vba i can do to assist in this? I know its asking a bit much, but ive been surprised in the past with how versatile vba is! (i.e mapping network drives). I asked the IT guys to do it over the server, but they started ranting about screen resolution, priority of other jobs etc etc.

View 2 Replies View Related

Change Row Background Color Using VBA

Nov 19, 2012

Try to find a way to automatically change the color of a row, based in changing the name in column A.

I tried conditional formatting but the name (or dates) in column A are not the same (always other and other).

I failed to adapt any VBA CODE (found in GOOGLE) because column A varies a lot.

Annex a photo and an excel example.

EXAMPLE FORUM HELP.jpg
EXAMPLE 1.xlsx

View 9 Replies View Related

How To Count Background Color

Apr 7, 2014

Is there a way to count the background color from a range of cell? for example: In a range of A1:B5 there are 5 cells highlighted with yellow background, the formula should give me 5 counts for yellow background.

View 11 Replies View Related

Background Music To A Spreadsheet

Jan 22, 2008

is it possible to have a music file play in the background of the spreadsheet if so how? and then if it is possible does it play constantly or will it stop if i perform functions on the spreadsheet or move sheets..

View 11 Replies View Related

Change Background Color Of Every Second Row?

Jul 30, 2014

I have a given som (general) range where I would like a function to change the background color of every second row in a visual basic function.

One could of course just loop through it and use the mod function, but I think there has to be something quicker.

I know about conditional formatting, but it is something I need to use over and over again on Ranges that will differ in size so I would like it to be a function I can just run as part of a sub.

View 1 Replies View Related

Blank Screen Background

Oct 15, 2008

I use a number of user forms and would like to dsplay them with a blank background ie not over the top of the spreadsheet. The colour of a blank userform would be nice! I do not want to make them the size of the screen.

View 4 Replies View Related

Setting Background Colour

Dec 4, 2008

I am wanting to create a function, callable from a worksheet, that sets the background colour for any given range of cells to a given RGB value. I am confused about the Color and ColorIndex properties. I'd have thought the following piece of code was trivial and would work but it doesn't.

View 4 Replies View Related

Textbox Background Color ..

Dec 29, 2008

How can I add some code to the routine below in order to change the background color into green?

View 7 Replies View Related

Change Background Using A Combobox

Feb 24, 2009

I need to change the background of an worksheet using a combobox!

Let's say that I have 10 or more picture with different names in folder "C:/picture".

I need to change the background of an worksheet selecting this pictures from a combobox.

I know that I can do this manually using "format/sheet/background", but I need to automate the process (in "C:/picture" folder, sometimes I will have more than 50 picture).

View 13 Replies View Related

How To Color The Background Cells

Aug 26, 2009

How to color the background cells using text ...

View 6 Replies View Related

Add Background Color Dropdown?

Jan 24, 2013

There is a color i like to use alot for shading cell background, and i'd like to add it to the background color dropdown. Now, i get to it by clicking "more colors" and then selecting it from that dialog. This is a lighter shade of yellow. I swear it used to be on the dropdown, but i believe it was removed at some excel version, so now its more of a hassle for me to get to it. Is this customization possible? In the macro recorder, it comes out as .Color = 10092543. Now, it will occasionally show up for a while under "recent colors" but then that will go away after a while.

View 1 Replies View Related

Put A Picture As Background For A Cell?

Jul 19, 2014

Can you Put a picture as a background for a cell?

View 1 Replies View Related

Sort By Row Background Color Possible

Jun 29, 2007

I have a spreadsheet that has differen color rows for certain data. Is it possible to sort a spreadsheet by row color instead of row header?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved