MS Excel

[gary21812114]

I need some help with MS Excel:

Please help me with the formula in ms excel where if I type a value or a word in cell B2 the value in cell C3 should reflect in B3

it was something like =IFB2<>0, C3... or something like that.........
pls help me with this formula

[gary21812114]

I was able to get the answer...
it is as follows =IF(B2<>"",C3,"")

[gary21812114]

Now I need further help on the same topic:..........

Can we make the formula in such a way that value in B3 reflects with a delay of 15 seconds?

[IPDO]

We don't have such formula for that but we can do some programming to get that delay.

NOTE: We do not require the formula =IF(B2<>"",C3,"") for this programming, hence you should remove that formula.

1. Right click on the Sheet tab at the bottom on which you are working.

2. Select View Code ; a new window will appear.

3. Enter the Code as shown below: 
 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then

 Range("B2").Select
                  If Selection.Value = "" Then
                         ' Pause for 15 seconds.
      Application.Wait Now + TimeSerial(0, 0, 15)
      Range("B3").Value = ""
                         Else
                         
      ' Pause for 15 seconds.
      Application.Wait Now + TimeSerial(0, 0, 15)
     
      Call MyDelayMacro
               
End If
End If
   End Sub
   
   Public Sub MyDelayMacro()

    Range("B3").Value = Range("C3").Value
   
   End Sub


4.  In the Debug drop down menu select compile VBA Project.

5. And you are done , Now close the window and update the cell B2.
    After every 15 Seconds the cell B3 is updated.

Thanks.

[Elsie Bee]

First day at this site, and I can't even figure out where I type/enter the question I have re: how to enter a specific excel formula. I know how to do formulas but stuck on how to enter this date formula or if it's even possible. Is there anyone out there that could guide me in the right direction?

[soybean]

First day at this site, and I can't even figure out where I type/enter the question I have re: how to enter a specific excel formula. I know how to do formulas but stuck on how to enter this date formula or if it's even possible. Is there anyone out there that could guide me in the right direction?

Your question should be posted as a separate topic.  I suggest you re-post it as a new topic.  When signed in to the forum, click on the New Topic button at the upper right part of the web/forum page.