Path not found, but the folders do exist
[code] Sub toPDF() ' This will copy a specified range('s) from ws1 & ws2 to ws3. ' Now you can...
I believe the problem is that you are not getting the sFileName from the original workbook. So I have added ActiveWorkbook.Save...
Hello Ready2go This may only answer some of your question. The macro below will create a PDF file of Sheet2....
Dear Hyside2, I really appreciate your cooperation and helpful answer. Thanks so much.
Try this instead =IFERROR(LEFT(B1,FIND(" ",B1)-1),B1) [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/givenname.png[/img]
I am not sure if this is what you are looking for but test it out anyway. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/1-2.png[/img]...
Oh! Please try this. You will need to change "Book1" on the line that reads (oFilename="Book1") to the name of...
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).