View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carlos[_2_] Carlos[_2_] is offline
external usenet poster
 
Posts: 9
Default x = textbox1.value (somethings wrong)

You need convert Hgt

e.g.
Hgt = Val(textbox1.value)
Image1.Height = Hgt - TT - TV

"CAA " wrote in message
...
I'm at a loss here. What have i done wrong?

put in the amount in a textbox and the image sizes, but if i want to
add something to the size like 2 other variables then something goes
wrong

Hgt = textbox1.value
Image1.Height = Hgt - TT - TV

Should i be coverting the value to a long type?
Thanks for looking
CAA


---
Message posted from http://www.ExcelForum.com/