User Forms

[DaveO]

This probably requires just a simple Yes/No answer (A little more than that would be appreciated!)

Can a user form be used to do away with a user entering any data int a spreadsheet? I want the user to be able to enter information into the form, for the sake of argument, weight of a parcel and service required, and have the input passed to a sheet which does all the calculations and then pass the result back to a text box or label on the user form.

If the answer is yes, I will go away and try and find out how to do it - I have not used user forms so I think the best way is to try them out once I know what I want is possible.

Dave

 

[santeria]

Depends on if you are willing to have a device hooked up.

Bar Code devices will read in information that is extracted from a database.

And Weighing machines that need minimal Spreadsheet intervention can calculate based on Chart Vlookups for rates, based on Address and weight.

The device may be capable of inputting all this in... in most cases, the templates can be supplied by the device manufacturers, at least that is what I have seen.

 

[kkknie]

The answer is definately yes. And I do it a lot.

I would guess that most of the calculations could be done in the form as well (assuming you know a little bit of VB). I've got 1 hour before I leave for a long weekend of golfing and debauchery, so if you post more, I can help for a while...

K

 

[DaveO]

Santeria

Sorry - Don't really understand as I never mentioned barcodes - Its a bit of a coincidence though as I have just this morning received a barcode reader through the post I bought on eBay

kkknie
Don't hang about for me - just running things through my mind at the moment - need time to start messing about with them


Dave

 

[santeria]

It was just an example.

Most of these devices are ready made for Office Integration so that you can use them for excel data extraction, and even Access together with Excel data Extraction if your system is large enough.

 

[DRJ]

To get you started

If you type something in a textbox on a userform and want to put that on sheet1 range A1 the code would be

Sheets("Sheet1").Range("A1").Value = Userform1.Textbox1.Value

 

[DaveO]

Understand you now - just thought you may have replied to another post by mistake. Thanks anyway

 

[DaveO]

DRJ

You do not relise how much that little snippet has helped me regarding how to access userforms in VB.

Thanks for the biggest kick in one direction I have ever had!

 

[DRJ]

DRJ

You do not relise how much that little snippet has helped me regarding how to access userforms in VB.

Thanks for the biggest kick in one direction I have ever had!

Glad to help.

 

[DaveO]

Although I have not been on the board for ages, You have always been helpful. I usually try and sort things out myself before I ask, but my kids were annoying me whilst I was trying to think so I apologise for taking the 'easy way out' - I just feel that I have taken abackwards step down the learning curve doing it that way.

PS DRJ
Only just got the humour in your signature - perhaps it is time I laid off the beer for a while as I have been into computers since 1978

I've got 1 hour before I leave for a long weekend of golfing and debauchery,

Tounge in cheek, withouth wishing to sound offensive, but doesn't that amount to the same thing - putting balls in holes!

Moderater

If you find that too offensive, please remove it - I will not be offended