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
Oct 28, 2013
How to make a text background on editable cells and print without text background?
View 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
Dec 18, 2009
I have to codes which work
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
Aug 26, 2009
How to color the background cells using text ...
View 6 Replies
View Related
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
Jul 19, 2014
Can you Put a picture as a background for a cell?
View 1 Replies
View Related
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
