I just had two outstanding EE Pros help me out with a particular Macro. I just need two twiks. The first is when you click on a yellow cell, you will see a data entry form come up. How do I get the $ format in the dollar entry point so that when you put a number in, it shows as a currency? And the second twik is how do I get it to make the calculation real-time instead of using the "go" button? When both cells are filled it could post the answer then when you moved from the cell, it could clear and hide the form until the next cell is clicked.
Not sure where your code goes here.
Here is what I have that works now:
Private Sub Worksheet_BeforeDoubleClic
Select Case Target.Address
Case "$A$1", "$F$7", "$F$20"
Here is what you sent me:
Private Sub btnOkay_Click()
If .txtDollars <> "" Then
ActiveCell.Value = .txtDollars.Value
The $ I'm trying to get the macro to recognize is the Currency field (first one) in the Form itself. So when I put a number in the form, it shows as a $ amount. The currency in the yellow box is already done with the formatting of the cell where then product is placed (e.g. A7).
The other Twik was to attempt to be able to skip the "GO" button in the form. So when you put both values in the form, it automatically put the product in A7 and then closed the box. If you double click the cell (A7 again), the form would come up with the $ value only (so as not to confuse the macro since if both cells in the form were filled it would just close.
Does that make sense?