Thread: Adding data to a cell via VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron1978[_14_] Aaron1978[_14_] is offline
external usenet poster
  
Posts: 1
Default Adding data to a cell via VBA

Hi All,

I would like to set up a piece of VBA code so that when a user adds an
entry in a cell in the speadsheet, a function is automatically run that
adds a new value to the adjacent cell. I guess the code would follow the
logic below but I can't see to work it out.

If ANUMBER is added to cell 1A Then
Run AFUNCTION(ANUMBER)
Add the value of AFUNCTION(ANUMBER) to cell 1B
End If

Any help would be greatly appreciated.

Best Regards,

Aaron


--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201
View this thread: http://www.excelforum.com/showthread...hreadid=546244

Reply With QuoteReply With Quote