I do not know why this does this. But I was able to work around the problem. Please try this...
Maybe try declaring the FSO as Object. "Dim FSO" without a declaration declares the FSO as a variant. Just a...
Each block is a named range. There are 6 Key colors which are based on the information in column “Y”(Rental...
I cleaned up the code. This will place next month and year in cell A1. So today is Sep30 2018...
This was tested in a blank worksheet (no data). The macro will place next Month and Year in cell A1....
Updated the code to include the possibility of blank cells in the raw data. If a blank cell is found...
Lets try this again. You will need 3 sheets. Sheet1, Sheet 2 and Sheet3 Sheet1 your raw data Sheet2 is...
Hey Thank you so much. Apologies for not been very clear on the question. Using your example, in the output...
I really need help with this one. I’ve been working on this for days but my code isn’t working. My code needs to check if Cell is a number. If cell isn’t a number, then it have to show UserForm and change the value of the cell from EntryBox. But for some reason after I press “OK”, it just switch to next Cell without changing.
Public Function test(x)
r = ActiveCell.Row
c = ActiveCell.Column
If IsNumeric(Cells(r, c).Value) Then
test = True
test = False
MyEntryForm.Label1 = "Error " & Cells(r, c)
If FormCancelled = True Then
Cells(r, c).Value = MyEntryForm.EntryBox.Value
I’m using the same formula to validate multiple cells in one column.
Code inside UserForm (if need):
Public FormCancelled As Boolean
Public Sub InitializeForm()
FormCancelled = True
Private Sub OKButton_Click()
I would like to understand where you are calling this function(test(x)), and what is the parameter ‘X’ you are passing in the function. If possible please provide the example macro file.
Email us at : email@example.com
“x” is the active Cell. I have another Cell that do the function “test” and to that cell is Data Validation attached. So it checks if cell “X” is working with formula test. And how can I provide an Example?
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).