LinkBack URL
About LinkBacks
Hello,
I need to call from Macro1 in Module 1 the "Private Sub Worksheet_Change(ByVal Target As Range)".
I tried with:
Application.Run "Sheet1.Worksheet_Change"
but it doesn't work.
Any help?
Thanks!
Hello,
I need to call from Macro1 in Module 1 the "Private Sub Worksheet_Change(ByVal Target As Range)".
I tried with:
Application.Run "Sheet1.Worksheet_Change"
but it doesn't work.
Any help?
Thanks!
Put your code in a separate subroutine. Call that subroutine from both the worksheet change event, and from Macro 1.
e.g.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This is not possible.I need to call from Macro1 in Module 1 the "Private Sub Worksheet_Change(ByVal Target As Range)".
post your Worksheet change code so that helpers can change it to work in a module.
Click the * Add Reputation below to say thanks.
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
When I read the question I think TS wants the opposite.
this is not possiblePlease Login or Register to view this content.
Try this
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
You right. Sorry.Originally Posted by dotchiejack
When I read the question I think TS wants the opposite.
this is not possiblePlease Login or Register to view this content.
I can't get idea of that. What kind of results is expected?
Last edited by KOKOSEK; 02-05-2019 at 11:40 AM.
Hello,
well, Macro 1 checks if all the column headers have an expected value "string".
If not, an error MsgBox is shown.
If an error is found I want to give the user to correct the wrong column header name.
I can do it withbut this doesn't allow the user to type on the Sheet.Please Login or Register to view this content.
The best solution would be:
- Error Found
- MsgBox Shown
- Let the user type on the Sheet to correct the mistake
- The Worksheet "recognize" the Change through- The check routine (Please Login or Register to view this content.) is performed again.Please Login or Register to view this content.
Thanks!Please Login or Register to view this content.
I think it will be useful if you attached a sample workbook ...
BrianAll,
Try something like
Change a1 to suite if needed.Please Login or Register to view this content.
Last edited by jindon; 02-06-2019 at 01:23 AM.
It works!
Thanks jindon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks