ScrollBar1.Value = CDbl(TimeValue(.Text)) * ScrollBar1.Max Text = Format(TimeValue(.Text & "0"), formatString) Text = Format(TimeValue(.Text & "a"), formatString) Text = Format(TimeValue(.Text), formatString) TextBox1.Text = Format(ScrollBar1.Value / ScrollBar1.Max, formatString) The UserForm_Intialize event setsup the limits on the scroll bar, depending on whether seconds or minutes is the shortest interval of interest. The TextBox1_AfterUpdate takes the user entered time and converts it to a standard format. The TextBox1_KeyPress event prevents the user from entering a non-time. The ScrollBar1_Change and TextBox1_AfterUpdate events link those two controls. Get a userform with a TextBox and a Scroll Bar and this code in the userform's module. There is also an assertion that the 2011 actually handles textboxes correctly, and it is the win versions that have it wrong.I actually see the point the MVP there is trying to make, but wouldnt that be a first? :) The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. First, be sure that the Developer tab is visible in the toolbar in Excel.
#Text box vba excel for mac for mac
There is a post on the topic at, and the answer is to unlock the textbox. You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor.
I think this makes sense without code, but if someone wants to see it I can mock up a workbook to attach. Of course, I could just unlock the textbox - but I have it locked and provide a scrollbar for people to update values. On Windows (and 2004 I believe) you can update the textbox without issue via code, but the improvements in 2011 seem to have changed how locked textboxes are handled. Excel 2011 does not play with locked textbox like the windows versions. Greetings - just wondering if there is a better workaround than locking and unlocking a textbox to edit it programmatically.
0 kommentar(er)
