![]() Because i've tried the menu and if the user so happens to enter an empty value, the next item on the menu will move up and thus resulting with inaccurate results. So for example, if 'Carrot' is in Cell (A1) then the value or the amount of carrot must be in Cell (B1)ĭoes this make sense? Sorry to be so vague. So that whatever the user types, it will be placed beside the cell named carrot. I managed to get it working but using i = 1 and then loop then i = i + 1.īut now i need the Carrot and the value(amount / foodAmt) that the user types in to be linked. This means that, if you want to use the Microsoft Visual Basic programming environment that ships with Microsoft Excel, you must ask for it, which can be easily done. It stays apart because most people would not need or use it. Basically i need to collate the orders based on what the user clicks on the menu. Microsoft Visual Basic is a programming environment that gets automatically installed when you setup Microsoft Excel. This is supposed to be an interactive menu to use when taking vegetable orders. SorryĪlso, attached is the file that i use. If you have more basic usage questions with Microsoft Excel. This forum is for general questions and feedback related to Microsoft Excel (all versions) as they pertain to the IT Pro community. I am not really sure if this is what you mean. Using Visual Basic within excel for iteration of f(x) Archived Forums >. The Version of my VB is Microsoft Visual Basic 6.3. Many many thank you for your help!! I really appreciate it
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |