VB problem, writing to a label object

dawgXdenta · Apr 27, 2009, 08:35 AM

I've been to the VB threads , i didn't find what i was looking for,
i want to write to a form object (I'm using excel) from within the code

kindof something like:

labelObject.write(someText)

this is how excel says i should do it

labelObeject.Caption = someString

this doesnt work however

it doesnt write to the label object at all

the reason I have the "someString" variable is because i want the label to change depending on conditions i wont mention here, coz that is a problem i got on lock

Why is VB so annoying isnt it an OO its hierachy is so weird to me

dawgXdenta · Apr 29, 2009, 04:19 PM

Case anyone ends up here: here is how i managed

labelObject.Caption = Str$(someString)

had to parse it works though

Mac Daddy · Apr 29, 2009, 07:39 PM

Thanks for the feedback and cool. I was going to look at this on the weekend for ya the only time I have for this stuff.

Cheers

dawgXdenta · Apr 30, 2009, 08:38 AM

vb is mindboggling, whats the deal with the dollar sign pfffffffff

Apr 27, 2009, 08:35 AM	#1
dawgXdenta DriverHeaven Senior Member Join Date: Apr 2008 Location: Gabz Posts: 1,371 Rep Power: 58 System Specs	VB problem, writing to a label object I've been to the VB threads , i didn't find what i was looking for, i want to write to a form object (I'm using excel) from within the code kindof something like: labelObject.write(someText) this is how excel says i should do it labelObeject.Caption = someString this doesnt work however it doesnt write to the label object at all the reason I have the "someString" variable is because i want the label to change depending on conditions i wont mention here, coz that is a problem i got on lock Why is VB so annoying isnt it an OO its hierachy is so weird to me __________________ "I just want to make sure that this sensation really is hunger before i go and eat... " Emma Obita You Tube

Apr 29, 2009, 04:19 PM	#2
dawgXdenta DriverHeaven Senior Member Join Date: Apr 2008 Location: Gabz Posts: 1,371 Rep Power: 58 System Specs	Re: VB problem, writing to a label object Case anyone ends up here: here is how i managed labelObject.Caption = Str$(someString) had to parse it works though __________________ "I just want to make sure that this sensation really is hunger before i go and eat... " Emma Obita You Tube

Apr 29, 2009, 07:39 PM	#3
Mac Daddy DriverHeaven Extreme Member Join Date: Jul 2002 Location: Ontario, Canada Posts: 7,950 Rep Power: 64 System Specs	Re: VB problem, writing to a label object Thanks for the feedback and cool. I was going to look at this on the weekend for ya the only time I have for this stuff. Cheers __________________ "My mom said the only reason men are alive is for lawn care and vehicle maintenance." - Tim Allen

Apr 30, 2009, 08:38 AM	#4
dawgXdenta DriverHeaven Senior Member Join Date: Apr 2008 Location: Gabz Posts: 1,371 Rep Power: 58 System Specs	Re: VB problem, writing to a label object vb is mindboggling, whats the deal with the dollar sign pfffffffff __________________ "I just want to make sure that this sensation really is hunger before i go and eat... " Emma Obita You Tube