Help about an automation i want to create

damav78

New Member
Joined
Sep 29, 2024
Messages
38
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
Hi, I would like your help in an issue that i cannot find a way to solve.
I have 2 cells.
The first one has a dropdown list with one option only available.
The second one is a formula cell that collects multiple data from other cells and its dynamic. It means that when i change values to other cells this cell is affected.
So what i would like to do is:
When the first cell is blank the values on second cell to change as normally do (dynamically).
If from the first cell i choose the predefined value from my dropdown list then the second cell to actually "lock" the current value that has at that moment and dosen't be affected anymore from any changes.
Thank you in advance
 
I have no way of testing it with a comma because in Canada the default is the dot.
Ok I could format all the cells in the column as numbers and use it like this. Can you just add the € sign at the end of the formula or this could affect any other formula I use with that cell like the one at the right of that cell?
 
Upvote 0

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Doing that could affect the formatting of the number in column T and the formula in the cell to the right. You could include the euro symbol in the header in T1 to indicate that the column contains euros: Κόστος Συσπόρου Σε Τιμή Εκκοκκισμένου (€)
 
Upvote 0
Dear @mumps you have saved me with a macro you create for me some months ago...
But I have a small issue that probable has to do with it. The file I use, works great on my windows pc but when I try to use it on my Mac the macro doesn't work, although I have enable all macros from excel preferences.
So I was trying to figure out why is this happening... and I read somewhere that it might have to do with the macro.

"The problem is probably the content of the macros. If the author of the macro did not take the Mac into account, this is one possible result. You will have to contact the macro's author to make sure it will work properly on a Mac."

So if you have some available time to check it I will be grateful.
Thank you
 
Upvote 0
when I try to use it on my Mac the macro doesn't work
Can you explain how it doesn't work? Do you get an error message? If so, which line of code is highlighted when you click "Debug"?
 
Upvote 0
The VBA version for the Mac is not exactly the same as the version for Windows. I really don't have much experience with the Mac version. Maybe you could open a new thread posting the macro I suggested and explaining in detail the problem you are experiencing. There are Forum members who are knowledgeable of the Mac version who may be able to help you.
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,702
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top