I have a button on my userform, lets call it CommandButton2. I have code that outputs at the very end a long value of 2 to refer directly to the button lets call that long ButtonValue. Now if I wanted to loop through a number of buttons using the long value my first thought would… Read More VBA how do I build reference to a userform object property from a string?

I have 4 option buttons and their caption is set to different cells. However, sometimes that cell value doesn’t contain any text, and I want to hide the option button from the Userform if that is the case. But my code is hiding the option buttons even if the caption contains text. I’m sure this… Read More How to hide option button on Userform if the caption has no text

In Word VBA, I want to be able to show a userform and input information in textboxes and checkboxes. However, I would like to be able to access and scroll in other word documents. So, I want a userform to pop up, insert text and click checkboxes, be able to scroll in other documents, and… Read More How can I show a userform and wait for code to run, while still being able to access other documents

Hopefully a simple question. I have some simple code for a combo box that runs during Combobox_Change(). Private Sub ComboBox1_Change() If ComboBox1.Value = "" Then Label3.Caption = "" Else Label3.Caption = Worksheets("Currency").Cells.Find(UserForm1.ComboBox1.Value).Offset(0, -1).Value End If End Sub Private Sub UserForm_Initialize() ComboBox1.List = [Currency!C2:C168].Value Label3.Caption = "" End Sub But when you enter something that isn’t… Read More How do I avoid Userform Combobox runtime error?