All Questions
Tagged with formatting vba
571 questions
0
votes
0
answers
97
views
Data Extraction from .txt file, formatting nightmare
I am writing code to extra data from a text file, the .txt file contains repeating sections in a 28x99(max) grid, the column size changes slightly depending on the data in the grid. For example below ...
- 1
0
votes
1
answer
91
views
VBA Custom ColorIndex
Is it possible to create a custom ColorIndex for VBA in Excel?
The workbook I'm working on has an excessive number of conditional formatting rules. I'm trying to convert those rules to a VBA script ...
- 15
0
votes
1
answer
32
views
Is it possible to highlight specific text in an InkEdit box used for search results?
This is the code I am using:
If matchFound Then
results = results & row.Cells(1, 1).Value & " | " & _
row.Cells(1, 2).Value & " | " & ...
- 1
0
votes
0
answers
52
views
Why is the email that VBA is generating not keeping the same font color i have in my excel sheet when copy & pasting?
This is the code (i know there's a lot of unecessary stuff) but my range from E13:H24 is a variety of colors from conditional formatting forumulas, but theyre not appearing correctly in the email ...
- 1
0
votes
1
answer
69
views
Date format issue when I try to find the first occurrence of names with associated dates
I am working with two columns in Excel:
Column A: Contains names (e.g., Giovanni, Maria, Leo, etc.).
Column B: Contains dates (e.g., 01/2025, 06/2023, etc.), in the format DD.MM.YYYY (e.g., 11.10....
- 632
1
vote
2
answers
60
views
Method 'columns' of object '_Global' failed error - VBA Access
Good morning everyone. I am trying to format an Excel file generated by exporting an Access query, I can correctly export the query and save the Excel file in the relevant folder, but when I call the ...
- 53
0
votes
2
answers
87
views
Excel VBA conditional formatting for certain columns only
I have a table with prices for products. For each product there is one row. For each row there are columns for several companies. Each company has 2 columns - one for old price and one for new price. ...
- 11
0
votes
0
answers
70
views
Excel VBA macro is unintentionally changing my conditional formatting
I have a couple of macros for my spreadsheet and it seems the main one I run keeps changing the "Applies to" rule of my conditional formatting.
The macro is extremely simple, it just uses ...
1
vote
1
answer
89
views
Excel/Vba How to conditionally change the number format of ALL workbook cells with numbers in them, based on their number values?
I think this is a unique question which I need help with.
This code does NOT work but I hope there is a syntax that would work and I would also need to know where to put it.
In which event and at what ...
- 334
0
votes
1
answer
136
views
How to bold specific words in text string - MS Word VBA
I'm very familiar with VBA in MS Excel. However, I'm totally new to VBA in MS Word.
I'm trying to do something ostensibly very straightforward: make certain text within a string bold.
I have Googled ...
- 1,518
1
vote
1
answer
114
views
Split sheet into multiple workbooks, keeping formatting and sheet protection/locked cells
I have working code in a module to split data in a worksheet tab into over 50 new worksheets based on the value in column A.
I need to also
(1) copy the sheet protection/locked cells
(2) copy the ...
- 11
1
vote
2
answers
69
views
Partial value font color in red using vba
I will see (1234.56) Dolar in Black when I run the following code
Sheets("Sheet1").Range("A1").Value = Format(-1234.56, "#,##0.00;[Red](#,##0.00)") & " Dolar&...
0
votes
0
answers
31
views
VBA 2 seemingly identical times in "HH:MM" format return different output
I have times in one column all "22:00" in "HH:MM" format. I run a function to get the shift pattern, which changes at 22:00.
"2" is late shift - up to 22:00
"3" ...
- 17
0
votes
1
answer
59
views
Getting Overflow Error in Excel when using Format() to format as date
I have a vba automation to concatenate some text but it's been giving me the "Overflow" error when changing the result to date in this specific file (works fine in others).
Function ...
2
votes
1
answer
49
views
How do I change my VBA formatting code so that the rule would read the cell value constantly and not only copy the values to the rule?
I'm writing a code which paints the number in the cell red if the value is not between the values in two seperate cells. The problem is that my code writes the values from the cells to the conditional ...
- 35