Hey everyone, just trying to create a userform to enter data into cells, specifically x and y coordinates. I have been playing around with it and not sure exactly what direction to take.
As there could be any number of points I will need some form of scroll bar or something. Can I use text boxs or something?? Cheers
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I have attached my worksheet. When you click the input data button I need the userform to pop up then to enter the x and y values in sheet 2..
Can this be done? How should I do it? Thank you
Can you explain a little more? Where exactly do you want the X, Y coordinates placing?
Sorry mate, over the top of the stuff thats already there in the drilling worksheet...with the x and y coorinates....So B4:C11 and E4:F13...Though there could be many more points so it could go to 500 or so....But thats where I need them...Cheers
I think you need a UserForm with 4 spinbuttons, one for each coordinate?
How will a spin button help insert a range of data?
I need a userform where i cam simply enter the required data and then click ok and for it to appear in the required cells..
Cheers
Last edited by stanysurfer; 11-02-2010 at 07:13 PM.
You mentioned ScrollBar
I meant in the userform so that I can enter large amounts of data...Originally Posted by royUK
Basically I want a table to pop up with liek 4 columns so i can enter data?
Is this not possible to do with a userform?
Four TextBoxes is about the nearest
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks