userform
Going Back and forth between Userforms
Hello everyone on my userfrom I have a previous and a next button the previous button on userform 1 contains a next button which the code looks something like this[详细]
2023-04-12 20:53 分类:问答Formatting Textbox in VBA 4 place decimal
Is there anyway that you can format a textbox format to have four decimal places at all time? I know how to do it with C# and Visual Basic using a masked textbox, but vba is a bit more challeging due[详细]
2023-04-09 16:44 分类:问答Is there a way to add an image to a MessageBox in VBA?
I am wondering if it is possible to add an image to a messagebox in VBA mainly, but if not 开发者_C百科any other languages.[详细]
2023-04-08 20:19 分类:问答Put code inside a loop to exit the loop after any mouse click
On a Userform, I\'m blinking a frame Off/On by toggling its visiblity.It blinks a variable number of times and then stops, but in between blinks it checks for user activity.If there has been a mouse c[详细]
2023-03-28 08:13 分类:问答In an Excel UserForm, how do I update a label's caption?
I created my first modeless UserForm in Excel and put an ActiveX label on it.How do I set the caption of the label so th开发者_如何学编程at it displays whatever is in Sheet1.Range(\"A1\"), and updates[详细]
2023-03-23 07:39 分类:问答Using the Properties Window to identify controls on a form
With a control selected on a form, at the very top of the Properties Window the name and type of the control are d开发者_如何学JAVAisplayed, and on the dropdown menu underneath there\'s a list with so[详细]
2023-03-11 11:57 分类:问答VBA Text Box displaying Currency
I have 开发者_如何学Pythona form with a number of text boxes for user input (this is in a User Form not on the spreadsheet). I have a few boxes that are related to currency and I need them to show the[详细]
2023-03-05 05:08 分类:问答Excel VBA Userform - Execute Sub when something changes
I have 开发者_开发知识库a userform containing lots of text boxes. When ever the values of these text boxes changes, I need to recalculate my end result values based on the textbox values by calling a[详细]
2023-03-04 13:16 分类:问答Method or data member not found
I get this error when I run my code.This is a continuation from this post: Adding a scroll bar to a label[详细]
2023-02-26 05:36 分类:问答Adding a scroll bar to a label
I have a label on a userForm and the data within it is in list form.The data is longer than the label.Without expanding the label, is there a way to add a scro开发者_开发知识库ll bar to it?Or is there[详细]
2023-02-25 19:36 分类:问答