Am I on the right path here? If I want to have different users input data into a spreadsheet by having them prompted for input (let's say 5 different categories), do I have to nest 5 separate applications? For example, have the user input data into cell A5, then move 2 cells to the right and have them prompted for data into C5, so on and so forth. Would this have to be done by 5 separate applications, or can I group the (methods) all together?
Sorry if this sounds trivial, but I'm an vba virgin. Thanx in advance for any assistance.
Just trying to understand it all????
-
-
-
You can do it with one UserForm and include all five inputs on that. Then use procedures to put those values into the appropriate cells.
-
Shades...thanx for your response.
I'm probably gonna need a lot more help than I have the nerve to ask for here. I understand about the InputBox, to a degree, and I can understand the concept, but what's screwing me up is after I've built the box, with labels and dialogue entry areas, I can't figure out how to assign the entry areas to a specific cell, (named or otherwise). I've gone into the properties of the entry area, but that doesn't seem to help, and I need to get my head around the correct syntax to do that. Unlike QuattroPro, Excel doesn't appear to have a very helpful glossary as to the names of methods or procedures and what they actually do, or else I just can't find it. It's probably old-hat stuff for many of you out there, but it's a whole new language for me. But again, I do appreciate the opportunity to visit your forum and try to learn from the experts. Wish me luck!! I'm gonna need it. -
I assume you are using VBA code for your InputBox. A typical method is to assign the InputBox to a directly Range or to a variable that is latter assigned to the Range. For Example
Range("A1") = InputBox("Please enter an Integer from 0 to 10")
You can add error checking to make sure the response is "legal" if you want The variable route is useful for this.
-
For Text or numerical data it's best to use the Application.Inputbox Method.
It offers you more filtering of it's data via it's Type property. Look it up in your VBA Help files. Post back if you require further help. -
-
:thanx: Thank You Shades, Tom, & Ivan for responding. For now, I think I'm going to inhale a Que book that I picked up and then try and apply what I can. I also got a response from Theo. All were much appreciated. Like I said, I'm going to try and absorb as much as I can from this book and then see what I can come up with. I appreciate all your assistance, and I'll let you know whether I'm successful or not. Wish me luck!
My biggest concern, as I stated before is getting my head around the syntax and the definitions of the various "methods" or 'procedures". With QuattroPro, it was very straight forward and Corel's help was outstanding. Simple things like getting a value or a number from a cell: {GetNumber} or {GetText}. Putting a value or string into a cell: {PutCell}. Tying into a second routine: {Branch}. It wasn't really rocket science, but each "method" or {Command} as they are reffered to, were well detailed in their function and use, and Corel's help was extremely good, and easy to intepret. Once again...Wish me Luck..and Thanx!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!