ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform runtime controls & Macs (https://www.excelbanter.com/excel-programming/331894-userform-runtime-controls-macs.html)

Jim Cowan

Userform runtime controls & Macs
 
I've created a form that adds multiple textboxs all with different names,
everything works fine on my windows pc (Excel 2002 sp3), but for a mac user
(Excel 2004 for Mac) excel crashes when they click in one of the textbox to
edit the text.

Set myTextbox = Me.Controls.Add("Forms.TextBox.1", "tb1", Visible)
With myTextbox
.Text = "Test"
.Top = 10
.Left = 6
.Width = 60
End With


Any help would be appreciated.


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com