Thread: show the input message of a data validation list on a textbox and set editable
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
HCS7 via OfficeKB.com HCS7 via OfficeKB.com is offline
external usenet poster
  
Posts: 2
Default show the input message of a data validation list on a textbox and
Joel wrote:
from:
Set ws = ActiveSheet
Set sTemp = ws.Shapes("txtInputMsg")

To:
Set ws = ActiveSheet
Set sTemp = ws.OLEObjects("txtInputMsg").Object
sTemp.Text = "Joel"

the data validation list only allows 200 characters, i am able to do this but
i cant edit the textbox and add more information to it? any help.
[quoted text clipped - 45 lines]
when click on validation list info of input message appears
help to be able to edit the textbox please

Thanks for that, but it still doesn't work, cos now the txtbox doesn't show
anymore

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Reply With QuoteReply With Quote