Questions tagged as 'excel-userform'

0
answers

Formula Optimization

Could you help me find a way to optimize the formula below? The spreadsheet has more than 125,000 lines with this formula in some 4 columns and is generating a lot of slowness to process the information and even to open it. =SE( $D125883="...
asked by 09.03.2018 / 15:22
1
answer

VBA - Max characters in the dropdown-list

' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _ "TESTE1;TESTE2;TESTE3;TESTE4;TESTE5;TESTE6;TESTE7;TESTE8;TES...
asked by 30.11.2017 / 18:10
1
answer

Edit 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 them as requested. However, I do not know how to edit these dropdown values. Can someone help me? Below is an example of two items that...
asked by 01.12.2017 / 12:01
1
answer

IF Condition - Display 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 the YES option in group2, a textbox i...
asked by 06.11.2017 / 11:01
0
answers

Opening excel in php on different servers

I have an excel file that stays on a server, for example: \192.168.0.1\arquivos\teste.csv And I have an Apache server on another server, for example: \192.168.0.2\www\index.php I want the apache server to put a button to open the file...
asked by 06.12.2018 / 19:12
0
answers

EXCEL: Form with filling in specific places

InthisimageIhave7"blocks" to be filled via form, they are side by side. As I do in vba a function that fills in these blank fields of TM1 and TM2 automatically, I want to include this function in a form to fill with the forward and back button,...
asked by 14.04.2018 / 05:30
1
answer

USERFORM: Move ListBox item up or down

I have a ListBox on a UserForm that reflects a list of the display order of 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 the ListBox, as shown in the figure: Is there a...
asked by 08.04.2017 / 14:40
1
answer

How to add a TextBox dynamically using VB

How to add a TextBox dynamically whenever the Userform (Combination Box or Data Validation List) is equal to "Outro (Especificar)" , using VB ? I'mlost,I'mnewatmakingmacrosandforms,usingVB.^^'IwasdoingwithDataValidation,L...
asked by 02.08.2017 / 21:25