All Questions
24 questions
-4
votes
1
answer
93
views
How to make Uppercase Month Names in Y axes of the Chart via vba?
Please run the following code.
Public Sub Macro1()
'Delete all charts
For i = ActiveSheet.Shapes.Count To 1 Step -1
If ActiveSheet.Shapes(i).Type = msoChart Then
...
- 121
-1
votes
2
answers
122
views
How to convert the phrase into sentence case, disregard the UPPERCASE words
I want to convert all the text to "Sentence case", but I need the UPPERCASE words to remain UPPERCASE. I would manually write it if the file wasn't ~50.000 rows.
A string could start with ...
- 23
0
votes
1
answer
114
views
Excel VBA advanced filter - uppercase
I'm using the following code to do first an advanced filter. Then I need to change the filtered range (except headers) to uppercase avoiding looping as it would slow things too much. But there is ...
0
votes
1
answer
2k
views
Excel VBA to Uppercase
Can someone tell me if the following code is optimized and correct for Excel VBA to Uppercase on cell focus?
Sometime it slows the Excel. Could there be a better version?
Private Sub Worksheet_Change(...
0
votes
1
answer
1k
views
VBA Convert Range to Uppercase
I would like to convert a Range (from "I5" to the last Cell) to Uppercase in an Excel Table
I calculate the last Cell and try to put it into my code but it always says "object required&...
0
votes
1
answer
932
views
Replace all uppercase text to smallcaps AND wdTitleSentence
I'm stuck with this problem for the past two days and I can't find a way to overcome it.
I've a document (400 pages) where I want to replace ALL the uppercase words to SmallCaps AND set the text as &...
- 47
0
votes
0
answers
80
views
Converting casing in MS word
The code below converts words in a specific style into title case, except for acronyms.
However, there are specific words that I would like to add for the exception and these words should stay in ...
- 41
-1
votes
1
answer
119
views
VBA Concatenate string with previous string value (previous value changes every few cells)
I am working on building data historical of Financial System.
I need a macro that reads if the cell doesn´t contain uppercase, then concatenates the text of this cell with the previous value that was ...
- 19
1
vote
1
answer
952
views
How to disable autocomplete in vba?
I'm creating the program for exporting several excel sheets to pdf with watermarks and form fields etc. Everything works smooth right now but the final pdf is quite large. So I was thinking about the ...
- 13
5
votes
2
answers
1k
views
How to maintain cursor position when enforcing Change() on a UserForm TextBox?
Suppose I have this following code in my EXCEL VBA UserForm:
Private Sub TextBox_Change()
TextBox.Value = UCase(TextBox.Value)
OtherText.Value = "FOO " & TextBox.value & " BAR"
End Sub
It ...
- 13.9k
-1
votes
2
answers
95
views
How to split multiple UPPERCASE/delimiter/text using regex? (VBA)
I've got 2k+ records with string followyng rule (LOCATION I UPPERCASE - text) x several times, like this:
I- TRZON - Fragmenty błony śluzowej trzonu żołądka w stanie przewleklego
powierzchownego (++)...
0
votes
0
answers
31
views
Get upercase within String Value
I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated ...
3
votes
1
answer
426
views
Capitalize Dynamic Range in VBA
(Coding rookie posting first ever question so please pardon my mistakes)
I'm trying to learn simple methods of data validation. I read another post similar to what I'm doing: convert-entire-range-to-...
- 33
1
vote
2
answers
2k
views
VBA: Put a space after or before a upppercase letter in a string
I have a sequence of texts that represent customers names, but they do not have spaces between each word/name (for example: JohnWilliamsSmith). However the words can be differentiated because the ...
- 307
3
votes
2
answers
4k
views
VBA code lower case to upper case using Mid string
I've gotten stuck with this VBA code. Any help would be greatly appreciated. I'm trying to change the first letters of 2 words from lower case to upper case. Also, how should I take the space in ...
- 71