• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Help

A

ananthram

New Member
Hi all,


The file in this link has echo feature but can i know how to do them using VBA?


http://chandoo.org/wp/2011/08/30/variables-conditions-loops-in-vba/
 
Ananthram


What do you mean by "Echo"

The word isn't used in that post at all?
 
Hi Anathram,


I dont have enough knowledge on ECHO.. I just know.. its something.. what my wife do, when I ask for something.. :)


BTW.. if you ask for for EACH (atleast three character matched :) then, we may try to elaborate..


Regards,

Deb
 
sorry hui and debraj sir echo was in CMD prompt :(


i mean the box pops to input values. i wanted to know how it triggers :(
 
Do you mean what triggers the input box?


Code: 
store.Value = InputBox("Sales for Store " & storeNum)

[code]reason = InputBox("Why are the sales deviated?", "Reason for Deviation", "Reason for Deviation")


When you click the button it runs a loop. It looks at each 'store' in the range and for each one displays an inputbox.


firstly the code is saying the store.value is equal to whatever the user types in an inputbox.

store.Value = InputBox("Sales for Store " & storeNum)[/code] will trigger the input box


I'm not sure where you are seeing Echo though
 
You must log in or register to reply here.
Back
Top