Search results

oh no >>>> hi there all your help was much appreciated, now that it all works i hAVE A Macro behind command button 1 which looks at the variables in combo box1 and text box, tne command button has call macro on it but this doesnt work any ideas :confused: as you can see im a newbie

hi i have a lable which opens up outlook, how do i populate the subject and message area Private Sub Label9_Click() Dim Subj As String Link = "mailto:seenan.marc@bsksyb.com" On Error GoTo NoCanDo ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True 'Unload Me...

one last thing it all works but the changes only take effect when you click in the textbox how can i get it to change without clicking in the textbox ?? :confused:

thx you guys are ther best. respect :D

hi guys thx but.... my combo box i.e has jan, feb etc when I select jan i need textbox1 to have 28 jan, feb etc when I select feb i need textbox1 to have 35 If ComboBox1.Value = "jan" Then textbox1.Value = "28" this is what isnt working ...... :(

hi all on a userform i have a combo box with values, what i need is; if i were to select a value in my combobox, this would populate my input box below will with a value, please help getting ,mega pressure at work :confused:

you guys........... thx so much 4 all your help that wa superb and keep up the good work ex :D cellent :D

hello any help on this pls desp

oops after the first comma i.e rja01, 1234

:confused: i have a column with usernames and numbers i.e rja01, 8765, sngg03, jkljkl344 and so on what i need is to remove all after and including the comma, please help thanking you inadvance