All Questions
43 questions
0
votes
0
answers
33
views
Fill a blank cell with a color before save, but clear it when data is entered in VBA
I have code that prevents a user from saving a file if certain cells are empty. The code fills the necessary cells with a jarring red color that forces the user to enter data before attempting to save ...
- 27
0
votes
1
answer
351
views
How to store fill and font color of every cell in a range in Excel VBA
When I refresh the data from my database, any fill/font color gets moved when new rows are added. I want to add to my refresh macro
Store current fill/font color information
Clear it all
Refresh data
...
- 11
0
votes
1
answer
77
views
Mirroring Sheet1 to Sheet2 for Interior Color only, through VBA
I have a schedule showing a lot of information. I would like to condense this onto a second sheet that displays the fill color only and none of the values.
I want that any fill color changes are ...
- 3
0
votes
0
answers
82
views
Fill blank spaces VBA
I want to fill the blank spaces in a table, where in some months there are debts that doesnt have information and i have defined the data set by the name "Base1", but when i tried to run it ...
0
votes
1
answer
333
views
Copy one cell to blank cells in a column, if another column has data
I am rather new at this but eager to learn :)
Unfortunately I have been struggling below below problem for the last few days.
I need to copy the value of a single cell (J2), to column A from cell A3 ...
0
votes
2
answers
922
views
Fill each shape with selected pictures from folder and crop them to fill - VBA - Powerpoint or Word
With PowerPoint, I have created several templates made of groups of shapes that I would copy to create nice image galleries in a Word document.
My idea is to automate the following process:
select a ...
- 15
-1
votes
1
answer
1k
views
How to get CATPart number and name into text editor in drawing using macro?
I'm trying to create a macro in CATIA. The macro should use a UserForm with the button. After clicking on the button, it will automatically fill in the text field with data (Part Name + Part Number).
...
- 15
0
votes
0
answers
275
views
Fill column based on the values of another one in a dynamic range and merge lines at the end for the cells within the same cable tag
I'm trying to fill a column with color abreviations based on number of times a text appears on another column.
In the next image you can see that I have in the column C, starting at line 5 a cable tag,...
- 29
0
votes
1
answer
546
views
Copy data from cell above in specific cell below
I have a table with years above and i want to copy it to specific cells below:
I want in example to copy years in (H1; I1) to (H78; I78) by choosing H78 and use Ctrl+V as shortcut , etc... i dont ...
- 1
1
vote
1
answer
161
views
Excel table fill color changes to white when changing cell number format
How do I retain the alternating color fill in an Excel table column while changing the number format of that column?
- 95
-2
votes
1
answer
7k
views
How do I Change Shape Color on Click in VBA?
I wish to change the color of a shape In excel upon clicking on It.
But I am new to VBA and not sure how to write the code for this.
Any method will be appreciated.
-1
votes
1
answer
854
views
Automatically copy the background color of a cell which is using Conditional Formatting, to another cell
I have just discovered VBA while trying to find a solution for the following scenario:
I have an Excel workbook with the following table:
And I'm trying to create a graph, showing each team's score ...
2
votes
1
answer
136
views
Use a macro to highlight cells with a background colour
I need my macro to delete rows containing a red cell.
I started by sorting the column containing red cells so that blank cells were at the top, then manually clicked the top red cell (row 100) and ...
- 55
0
votes
2
answers
859
views
Auto Fill Sequential Dates Until Next Row Down has Value
I am trying to pull down the date column to fill in the next sequential dates in the blank cells until the next cell down has a value in it. For example, the blank cells in the highlighted date range ...
0
votes
1
answer
606
views
How to reliably change the fill colour of a rectangle using an animation timeline via PowerPoint VBA
I am coding using PowerPoint VBA, but am having difficulties trying to reliably change the fill colour of a shape (rectangle) using an animation timeline and msoAnimEffectChangeFillColor. What happens ...
- 675
0
votes
1
answer
480
views
Fill combobox with only numbers
Hello I have this Excel Spreadsheet
I would like to fill my combobox ComboBox1 only with the numbers in the given range.
So far I used this code to fill a combobox
With Worksheets("mySheet")
...
- 431
0
votes
0
answers
47
views
Iterate through excel cell ranges and mimic color fill for both
In excel using VBA, I am rying to write a formula that takes in 2 columns (or ranges of cells) as arguments. Iterate through each cell of the arguments and assign the cell's fill/color of the first ...
- 1
1
vote
0
answers
49
views
How do i avoid "Subscript out of Range?
I am having an issue with the "Subscript out of Range" error message. I got some help writing a code that loops a long list of stocks. The code basically makes all of the vectors even so i can use it ...
- 41
3
votes
1
answer
675
views
CorelDraw VBA Hatchfill color
Anyone have an idea how to get the background and line color from a custom hatch fill?
the following code fills the selected shape using data from textboxes
ActiveSelectionRange....
- 239
0
votes
1
answer
162
views
Add blue triangle to each slide - fill not working
I add a small blue triangle to each of my visible presentation slides that dissolves in after all other animations. This is a visual cue when doing a presentation that I am at the last animation on ...
- 979
0
votes
3
answers
2k
views
Search row for cell color and color a given range if condition is true
I have a code in which if the cells in a given range have the word "Yes" they highlight in red. Since the range is really big I also want to shade in red columns A to I if any cell in the same row is ...
-1
votes
1
answer
2k
views
Excel VBA autofill across and down
Ok... I am struggling with something that is probably simple... I have a formula in cell B2 and I want to fill to the last cell that contains data or formatting (same as when you press CTRL+END) or in ...
- 179
1
vote
1
answer
994
views
VBA code to fill a webform
I would like to create a code in VBA to complete some fields in a webform. Due to privacy-matters I can't copy the whole code of the form. However I can sent the part, where I'm stuck. To complete the ...
- 11
0
votes
1
answer
170
views
Im unable to get click button on VBA script to work. Any advice?
Im automating a form with excel to autofill and submit. I am able to fill my form but I can't get the submit button to work. I've tried about 50 different types of code and I cant get it to work. ...
-3
votes
1
answer
2k
views
I want to fill a column based on another columns [closed]
I want a VBA function that fills column c based on the following criteria.
Note: I cannot use a formula because column c already has values.
IF B is blank then C equals -D
I want this to work for a ...
0
votes
2
answers
41
views
Fill between rows based on rows on first column
I have a data that looks like this
I would like to have a formula/vba that makes it like this
Any ideas?
I am very new in Excel
- 67
1
vote
2
answers
2k
views
Fill Cell Down to Adjacent Columns last cell NOT from top row
I am trying to fill down a formula to the bottom cell of the adjacent column. Specifically Fill column A to the bottom row found in Column B. I can achieve this using the following code:
LastRow = ...
- 324
0
votes
1
answer
1k
views
Auto fill sequential numbers column A according to the row count of column B
I'm trying to fill item numbers automatically when I press a button. Here is my code:
Dim ws As Worksheet
Dim lastRow As Long
Set ws = ThisWorkbook.Sheets("BİLGİLER")
lastRow = ws.Range("B" & ...
1
vote
3
answers
235
views
Create macro to count from a sheet and fill the count in a table
Initial Information
I have sheet1 which has the data with multiple columnn, and I have named the data ranges as well.
My second sheet has kind of a dashboard where I need to put the count according ...
- 157
0
votes
2
answers
68
views
How can i search the numbers in order?
My problem is the as follows:
I have 3 columns and 20 rows, that contains numbers.
There is a line with numbers between 1 to 20 in order crescente, the other cells contains bigger numbers then 100 or ...
- 11
0
votes
3
answers
3k
views
Fill in missing dates
I am working on big data set and manually filling the missing dates is very tedious work. I want to automate this by applying Excel formula or VBA code which can help me fill all these missing dates.
...
2
votes
1
answer
91
views
Put a fill color in a specific cell
My program loops through each row of data in a sheet. Then when it errors, I want to put a fill color on that specific cell.
Is there a way to put a fill color in a cell without using Range?
On ...
- 431
0
votes
3
answers
262
views
Conditional color coding in Excel
I have a fairly simple question regarding Excel and VBA, but because I'm new to VBA, I have no idea how to implement it.
I have an entire column full of a color code. The cells in that column say ...
- 65
0
votes
2
answers
2k
views
Excel VBA update fill of cells based off of criteria
My code is in VBA and updates the value of a cell based off of two criteria. I've commented my code fairly extensively, so I'll paste it below first. I've changed comments by adding two more ...
0
votes
1
answer
738
views
How to fill linear in blanks in number series?
I am new at VBA and trying to figure out how to fill a number series using VBA. The blanks between two numbers can be one or several cells. I want to fill it in a linear way. Note that the percentages ...
- 3
0
votes
2
answers
5k
views
VBA fill cells by random numbers depending on other cells
I am working with Excel 2013 and I need to fill the range of cells by random numbers. To be exact, Range(B1:B4) fill by numbers in order to value of cells in previous column, I mean in Range(A1:A4). I ...
- 44.2k
-1
votes
1
answer
2k
views
Excel Macro for Linear Series Fill
I have a set of data in excel. Population in millions by year, however there are gaps in the data that I need to fill. See example below
Year--2013--2014--2015--2016--2017--2018--2019--2020
Male-- ...
1
vote
1
answer
111
views
Excel VBA codes about background fill
I work with MIT Excel tables. I need to copy "cell fill" to "another fill" and I've done this by using this code:
Sub Macro1()
Columns("A:A").Copy
Columns("B:B").Select
Selection....
- 11
0
votes
2
answers
917
views
Using RandBetween to fill a range of cells
I want to generate a range of random numbers in cells A1:C6 using the RandBetween function.
When I try this code
Range("A1:C6") = WorksheetFunction.RandBetween(10, 1000)
each cell is filled with ...
2
votes
1
answer
3k
views
Find a value and .filldown over multiple subsequent ranges?
VBA newbie here. I have a dynamic list of multiple groups. Each group lists the leader of the group at the top with the members of the group below. There is a primary key in Column A next to each ...
- 49
1
vote
1
answer
206
views
Adding color via macro in excel
I have 13 columns of information about our current inventory - preowned cars
They are sorted by make model year etc
I would like a macro to look at the 8th column (Make) and change the fill color of ...
- 11
3
votes
3
answers
4k
views
Use findnext to fill multidimensional array VBA Excel
My question actually concerns a matter that extends on EXCEL VBA Store search results in an array?
Here Andreas tried to search through a column and save hits to an array. I am trying the same. But ...
0
votes
4
answers
16k
views
excel vba filling array
I have the following problem. I have a userform with entry fields. The user is going to enter a number for participants. I have four groups of participants:
Group A: 5
Group B: 6
Group C: 1
Group D: ...
- 3,271