All Questions
10 questions
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
1
answer
552
views
Formatting Multiple Controls in an Excel UserForm using VBA
I have had a hunt around and have got to a point where I am almost sorted but can't quite complete.
I have the following:
Sub Formats()
'Form Setup
'----------------
With AuditForm
...
0
votes
1
answer
1k
views
Is there a way to change font color of portion of a string in VBA userform's label?
I'm trying to change the color of a portion of a string that is loaded into userform's label based on certain conditions. My attempt is to find the starting character and length of the string I want ...
- 31
0
votes
1
answer
5k
views
How to format date to UK date in excel vba
I have created a userform which looks at several cells inputting dates. Strange that it is very temperamental when it formats the date as UK format. When I initially written the code it would format ...
- 265
1
vote
1
answer
2k
views
VBA Format Userform Numeric Output
I have a spreadsheet/userform combo that takes user input to calculate product pricing/percent tax/and square footage in consideration to output a total cost for flooring in one of the userform's ...
- 107
0
votes
2
answers
416
views
Formatting User Form Controls
I am trying to format controls on each of my User Forms similarly, but what I have formats all controls on a User Form instead of just the labels or just the textboxes.
Here is what I have:
Private ...
- 11
0
votes
1
answer
191
views
Insert result of userform into heading
I need to insert the result of my userform into a header but i don't know how to combine my codes into a final project : Photos and code below
i need the header OK Button to
1: Format the header ...
- 19
0
votes
1
answer
65
views
Changing font color in conditional formatting
I am trying to change the color of a range of cells ("A" to "N") depending on the value of a defined cell, in this case the value in cell "H". I need to change to white and bold for the cases "...
- 13
0
votes
1
answer
95
views
Conditional Formatting VBA
I am building a form to enter account information and order status. Each row needs to change based on the value of one of the cells on the same row, on this case cell "H". I can easily achieve this ...
- 13
1
vote
4
answers
5k
views
Global VBA date format and decimal separator
Is there a way to change VBA settings globally on PC to accept dates and number on a specified format? (on my case dd/mm/yyyy and comma)
Changing Excel settings doesn't solve it for me.
As an small ...
- 163