dcsimg
Results 1 to 2 of 2

Thread: Need a Macro to enter formula

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2018
    Posts
    3

    Need a Macro to enter formula

    Hi people,

    I am using a user defined function formula in my excel sheet. The formula is,
    PlaceBO = (Exch, TrdSym, Trans, Qty, LmtPrice, SqOffValue, StoplossValue, TrailPoints, OrdType, TrgPrice, cTag)

    I am using this for trading. I tam using CONCATENATE formula in column "I" which gives result as follows,


    =PlaceBO("NSE","DABUR","BUY",60,410,3,1)

    =PlaceBO("NSE","HCLTECH","SELL",25,915,6,1)

    The values in columns D:H keep changing. And so the values in column I. What I am currently doing is whenever a order formula appears at column "I", I will copy it manually and paste it in adjacent cell at column J. Then in that cell (in column J) I have to double click and press enter. Then only the order will pass.

    How to make it through vba code to search the column "I" for orders and place it in column J.

    Thanks in advance.

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Java (JSP) Hell!
    Posts
    5,337

    Re: Need a Macro to enter formula

    Doesnt your user defined function work with ranges?
    Ie pass the values of the range to the function to retrieve the values.
    Or is it that your function isnt auto running when it receives new values in the cells?
    Is the spreadsheets auto calc function turned off?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width