Got a few questions related to the InputBox via VBA in excel.
I've used some basic VBA before,first time trying to use a inputBox.
Anyways:
1.Can an InputBox be 'confined' within 1 sheet only?
example:
i create 2 sheets,1 called "data",other called "formulas".Can it be set up in a way that the InputBox would only pop out if i click onto the sheet "data".While if i'm in sheet "formulas" the InputBox wouldn't popout?Same goes for the action of opening excel,popout shouldn't pop once i open excel,but only if i switch/click into the tab "data".
2.How to make InputBox log its data into specific cells,with automatic row transitions?InputBox has to loop too.
example:
i would link InputBox to log its entries into Column A.
Now,it pops out,i enter data,it enters that data onto A1.
Then,automatically,InputBox loops,it pops out again,and once i enter a data for 2nd time,it enters that data onto A2.
So,it goes to next row after each loop(i guess i could set up the next row featur myself with LR+1 and End(xlUp).Row.But i stillwonder about the loop function).
Then,there would have to be a way to manually stop the loop when wanted,so it wouldn't 'block' the excel file.
3.Is it possible to enter 2 different data for 2 cells via same InputBox?
Like intering "4evra,10" in InputBox,and the excel automatically entering it as "4evra" in A1,and "10" in B1
Thanks in advance
Bookmarks