Search results for query: *

i got the solution!!! you have to specify the sheet and the name of the textbox e.g MyVariable = Sheets(1).TextBox1.Text cheers for ur help guys... any one want to run there eyes over the code and tell me anything else that i've done wrong, or could be done better??

CoilQDir = Me.TextBox2.Value is where the program stops yep got a closing \ on the end of the directory

right here's me code.... it's a bit messy as it's one of the first ones i've done, i declare at the top CoilQDir and SaveDir, then just below i try and move the textbox information in the variables.... hope this makes sense to someone! Cheers guys Sub Load_Spec() ' ' Load_Spec Macro ' Macro...

i've done as u said and still get the same error... it's just normal Excel 2000.... The textbox is used to specify the directory where a file is being saved, the name of the file is automatically created all the automatic creating of file name and organising information works fine, it's just...

i try that and it comes up with : Run-time error '424' Object required i thought it would be easy, but i'm sure i'm missing something really obivous.... i'm using excel VBA, does that make a difference?

hello programmer types... how do u pull the information from a textbox?? i thought it would be really easy, i managed to do all sorts of things but not pull information from a textbox and use it. Sorry for asking such a easy question but the help file don't tell me (well i can find it...) and...