Re: $$Excel-Macros$$ Text Box - Properties

2012-02-06 Thread Cab Boose
tialize if the linked cell > will always be in the same workbook as the userform). > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff > *Sent:* Saturday, February 04, 20

RE: $$Excel-Macros$$ Text Box - Properties

2012-02-06 Thread Asa Rossoff
s the userform). Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, February 04, 2012 5:38 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Text Box - Properties The Active X Text Box control can be link

Re: $$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Cab Boose
Hi Asa Thankyou very much for the code. Magic. Will be using the info you provided. Will include in ;my library. Another similiar question being posted shortly re vlookup in text box, another little project. Thanks Charlie On Sun, Feb 5, 2012 at 2:37 PM, Asa Rossoff wrote: > The Active X T

RE: $$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Asa Rossoff
The Active X Text Box control can be linked to a cell, but I think it is only available for use on a worksheet, not a userform. and everyone keeps telling me to avoid Active X controls on worksheets like the plague, anyway. To duplicate the linking behavior, you'll have to use a little VBA code