If at least the initial post was what any forum expects for : a smart enough explanation of the issue, a well description of the context, …
But we have here a poor initial post with maybe the dumbest title I have ever seen :
'vba macro' in the 'VBA Macros' forum ‼
We have a winner, 'well done' … ★
As a per forum rules : « Use Relevant words in the Title and in the tag Box, This will aid future searches. »
Do you really think your title is so relevant according to your need / issue ?!
How can this thread may help someone in the future with such title ?
As this is the VBA Macros forum so these two words are useless in a thread title !
Hui was so gentle to give you a solution in post #2 of course according to your initial post.
If I were the first to answer I should have block this thread until the title would be corrected …
Some members here are moderators on other forums with basically the same rules,
so when they saw such 'clever' title they directly moved to the next post, like many other helpers …
How could Hui - in fact anyone - guess what you have explained in post #5 ?!
Your words « the exact situation » but this situation must be well elaborated in the initial post !
Again, if I were the first to answer I could have locked this thread according to your previous infractions
- you have created duplicate threads, you was notified several times to be explicit in the initial thread, … -
but as you have attached a picture of the error message confirming what I though since the previous post,
Ok, let's play so my answers were at the level of your initial post but opened to any smart enough reader …
I gave you a chance for your thread title in last sentence of post #9 but you ignored it.
So how could you dare to create your post #23 ?‼
How can you hope to receive any help with such poor explanations like in your last thread
msgbox by vba,
like receiving at the Festival de Cannes a new palm, a 'winner' again ‼ ★★
A new guessing challenge, no clue of what you are talking about, we do not have any crystal ball and we are not mind readers !
So do not be surprised to not get any answer without adhering to the obvious forum rules whatever the nickname you may use …
______________________________________________________
If you totally agree with the above, go back to post #22, well read it as I'm still expecting an answer to your 'fridges & beers' situation !
As without the assurance that you well understand your situation, what happens and why, I couldn't help any more, just a waste of time …
Like in your future threads with poor initial posts.