I have posted an example sheet with this in action.
Hope this helps.
Hi guys,
I've been trying to work out how to use a command button on a form to open another userform. I can't for the life of me work it out.
Can anyone help???
That's what I was alluding to earlier, and I would just make it non-visible until you enter one of those textboxes, then use ActiveControl to trap it.Originally Posted by WillieC
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Would you have a piece of code that I could insert? I can't get it going.Originally Posted by xld
Cheers again for all your help
Can you post your workbook again, I have deleted it?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Removed
Last edited by WillieC; 10-09-2008 at 06:03 AM.
Hi there,
So far the form is working well. I have come across just one problem. When testing the form with more than one user, if they both clicked ok to store the data it come with conflicting interests. How can I program my form so that more than one user can put the data onto the spreadsheet at the same time?
Morning, XLD. Any joy with my question?
I thought you had overcome the problem, that is how I read the last post post of yours, and you removed the file.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I had resolved the previous problem. The one I have come across now is that 2 users can't enter the same data at the same time. If they both click ok at the same time then a conflict error comes up.
Hi there,
I've uploaded the file again in the hope that you or somebody else can help, XLD.
Basically what I need done is for two or more users to be able to click OK at the same time and for the data to go onto the worksheet instead of getting conflicting errors.
Apologies for being a nuisance but this is doing my head in lol
Sorry, there is no point in hoping that I will help, I avoid shared workbooks like the plague and have no idea of how to solve the problems that they create.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
No worries, XLD, hopefully someone else can help.
Thanks for all your help so far. You've been a star
Another question for you guys if possible.
How do I have it so that if a certain option is chosen from a combobox then other fields are greyed out and can't be used??
Presuming you are using the combo boxes as drop-down lists (no editing), you should be able to use the change event of the combo box and trap either the val (if single col box) or better yet, the list index.
Sorry, GTO, what do you mean? I'm quite a newbie when it comes to VBAOriginally Posted by GTO
Hey there WillieC,Originally Posted by WillieC
Presuming you were asking as to disabling another combo/text/similar control based on a certain value (option) being chosen, I was just answering that this is possibly a couple of different ways.
Here's an example that disables the 'AddRemove' box anytime that "Mat Form" is chosen in the 'WhereFrom' box.
Mark
[VBA]Private Sub cboWhereFrom_Change()
If cboWhereFrom.Value = "Mat Form" Then
cboAddRemove.Enabled = False
Else
cboAddRemove.Enabled = True
End If
End Sub
[/VBA]
Hi Mark,Originally Posted by GTO
That's worked perfectly. Thanks very much mate.
Just two other things that I could do with some help with.
1. When more than one user is using the form, if they click on OK and Save at the same time, a conflict error comes up as the form tries to enter both sets of data into the same row. Any ideas how to solve this?
2. When a user opens the Form, I'd like Excel to minimize so that the form will appear on screen and can be used without having to have Excel in the background.
Thanks again for all your help
Hi Mark,Originally Posted by GTO
That's worked perfectly. Thanks very much mate.
Just two other things that I could do with some help with.
1. When more than one user is using the form, if they click on OK and Save at the same time, a conflict error comes up as the form tries to enter both sets of data into the same row. Any ideas how to solve this?
2. When a user opens the Form, I'd like Excel to minimize so that the form will appear on screen and can be used without having to have Excel in the background.
Thanks again for all your help