Most voted "excel-userform" questions
13 questions
Sort by count of
-
2
votes0
answers57
viewsFormula Optimization
Could you help me find a way to optimize the formula below? The spreadsheet has more than 125 thousand lines with this formula in a 4 columns and is generating a lot of slowness to process the…
-
1
votes1
answer1600
viewsIF condition - Show or Hide Textbox
Expensive, I have 4 optionButton (2 different groups), where 2 represent "Yes" and "No" for two different questions. What I want to do: When the user chooses the NO option in group1 and then chooses…
-
1
votes1
answer152
viewsVBA - Maximum character in dropdown-list
' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _…
-
1
votes1
answer2090
viewsEdit data from a Dropdown List in Excel
I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit it as requested. However, I don’t know how to edit these dropdown values. Can anyone…
-
1
votes1
answer284
viewsRuntime error 13. Incompatible types
I was building a simple listing, and came across the 'Runtime Error 13. Incompatible Types'. When I Clear it tells me that the error is in the two lines of code of my 'If', referring to the dates.…
-
1
votes1
answer1287
viewsCorrect formatting for excel vba time
Good afternoon! I’m finding a problem that I thought was basic but that I couldn’t solve. I have a Userform (Entradas) to register entries. These entries are played to my spreadsheet in Excel. In my…
-
0
votes0
answers344
viewsUSERFORM: Move Listbox item up or down
I have a Listbox in a Userform that reflects a list of the order of display of the items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in…
-
0
votes0
answers174
viewsEXCEL: Form filled in specific places
In this image I have 7 "blocks" to be filled via form, they are side by side. As I do in vba a function that fills these blank fields of TM1 and TM2 automatically, I want to include this function in…
-
0
votes0
answers1062
viewsChange data in a spreadsheet through a listbox
I have a form with two text boxes, three command buttons, a listbox and some Abels. The purpose of the form is to list data that is entered in the database (which is the excel spreadsheet itself).…
-
0
votes0
answers115
viewsHow to force Excel to respect formatting while expanding a dynamic table?
Good night, you guys. I reached my limit of reason with excel. I created a template for a checksum checklist. However, when inserting more rows dynamically, through the use of userform, excel simply…
-
0
votes1
answer66
viewsListing in chronological order | Visual Basic
Good afternoon, how do I order the times chronologically without affecting the dates in excel, using Visual Basic? I have a spreadsheet where are saved the entries I do by VBA. In column G are the…
-
0
votes0
answers14
viewsSearch listbox index from two inputs ofTextbox
Good afternoon, The goal is to find the index in the Listbox corresponding to two textbox values. Textbox1 looks for the value in column 0 and textbox2 in column 1. Both of these values in listbox…
-
-2
votes1
answer670
viewsHow to add a Textbox dynamically using VB
How to add a Textbox dynamically, whenever the Userform (List Data Combination or Validation Box) is equal to "Outro (Especificar)", using VB ? I’m lost, I’m new to making macros and forms, using…