background

I have a workbook with a connection. I have gone to connection properties and set it to refresh periodically in the background. But I don’t know if it saves the document after the refresh. I don’t think so because the time of last modification of document doesn’t change. So I’m trying to...

Hi all, Thought this question would have been raised in the past but can't find the similar situation I am looking for. At the moment I have two separate macro's that I want to combine. One of the macros retrieves data from one workbook and replaces the data in another workbook. The macro...

Hello, I am trying to write/find a correct vba code able to sum the amount in a colored cell based on two conditions : the color of the background and based on another condition (here the fruit) You can find a easy table showing the situation : I want the formula to sum the amount in the cell...

Good Morning, I was wondering two things, both interrelated: 1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as...

I'm looking for a way to determine the number of the color set to cell. I have a macro that loops through creating a column of cells with the number background color... But I can't seem to find the corresponding color from the fill drop down. I have a table and use the color number to set the...

HI, I am trying to loop through all the cells in thisworkbook and change the background color to vbyellow. My code so far is as follows: Sub testdata() Dim nm As Variant For Each nm In ThisWorkbook.Names Range(nm.RefersTo).Interior.Color = vbYellow Next nm End Sub It draws an...

can someone help me why my userform's background image in my pc is llooking good but when i run it to my friend's pc the background image of the multipages will become small..

I am trying to create conditional fomatting that changes the background color of a cell based on a simple conditional formula, but I want the color to come from the background color of another cell. For example, assume I want to create conditional formatting that changes the background color of...

I have written the following code that clears a page of data, copies the new data from another book, selects the new region and turns it into a table. It all works except when I add new data it shows up but the added rows do not format alternating row colors like the rest of the table. They...

Hi everyone, For an app under development, I need the user to: 1) Select a range of rows within a single column (say, A5:A15) 2) Color the background of the selected range. 3) Click on a button that opens a UserForm where the selected range is shown ( e.g. within a text box in the UDF, labeled...

Hi can anyone tell me if it’s possible to have a different background say on sheet 1 when a user opens up a spread sheet. I assume it may be a VBA Code that can do this . If anyone knows it would be great to hear from you thank you

The following image shows a report I produce on a weekly basis that I would appreciate assistance in creating VBA code to automate adding in the various cell interior background colors. It’s important to note that I would like the finished code to treat the cell range as dynamic since the...

Hello I need a script that will set font color to match that of the cell background color. My aim is to hide the texts in the cells. I have groups of rows with different background colors. The data range is A20:O68 Thanks in advance

Hi, I am wondering how to do this background in excel. Grid lines are not showing and the focus is just on the worksheet https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0

Hi, I Would like to add picture as a background of cell comment, When i click on the cell comment should be show with the background picture, Does anyone know how to can do it? Regards!

Hello All - Firstly, I need to apologize for the background noise. I am sitting in a tavern editing a lengthy list from a recovered hard drive. It wasn't until I played the video back that I realized how noisy my environment is. BTW - This same environment is protecting me from chronic tedium...

Hi I want to change the background color of a userform when a user click anywhere inside the form. Change the color different from previous one whenever user click on the form. I tried the following code but did not work. Any help would be very much appreciated. Private Sub UserForm_Click()...

Quick question because my mind is blanking- I have a macro that I'd like to have run if the value of Cell "A1" does not equal the value of Cell "B1". I'd like to insert the piece of code in the front part of the macro. If A1 does equal B1, a msgbox opens that says "hello". p.s. Sheet is named...

A spreadsheet I'm working on is calculating days since an injury has occurred. I have a macro set up in my VBA editor that recalculates it every (x) minutes/hours/whatever I set it up as. When I paste the object into powerpoint to run on our warehouse displays it will refresh a few times, but...

Hi all. First time poster here. I've used this site for quite a while to increase my Excel abilities and I thank you all for your great insight. This seems like it should be simple, but it has me scratching my head. Hopefully, someone can help me out. I am looking for a formula that would...