Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using part of a string value
Is there any way to grab part of a string that's the current value of a form control? The Characters property provides the exact functionality I need, but it doesn't seem to apply to form values. Thanks- Spon349
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Abstracting a form from its action
How do you abstract a form from a task which it executes? I have a simple form which allows ths user to select a month from a drop-down box, and then click either OK to bring about an action based on that selection, or Cancel. This works fine if I use it for one specific task, e.g. setting...- Spon349
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Unprotecting a worksheet
I'm trying to unprotect an Excel worksheet from within a macro (when the sheet has previously been protected with a password), but I keep getting the following error message: "Unprotect method of worksheet class failed" The macro executes from a button placed within the sheet I'm...- Spon349
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
