macros and vba

I'm creating a database of a library, I created a macro to check if the expiry date of the request that the user made has already passed, if this has happened the cell value should be "Expired Term" otherwise it should be "Pending" , but when the program executes the macro it always shows the...

I have a macro to check if the user has entered the "Username" and the "Password" correctly depending on the data present in another excel file, it happens that I enter the data correctly and the program detects that the password or user is wrong Private Sub bt_seguinte_Click() 'Oculta as...

when I start my form I'm getting the error "Type Mismatch" Code: Private Sub UserForm_Initialize() Dim split_name() As String, name_person As String Dim c As Long, contar_usuarios As Long Workbooks(OtherBookPath).Sheets("Usuários").Activate contar_usuarios = Cells(Rows.Count...

When I try to open the Form I get an error ("Application defined or object error"), can someone help me? lb_erro_email.Visible = False lb_erro_confirmar_email.Visible = False lb_confirmar_checkboxes.Visible = False Select Case True Case Trim(tb_email) = "" And Trim(tb_confirmar_email) =...

I'm creating a macro in vbaque transcribes the values that were assigned to the variables in a specific Excel sheet, it happens that when the program tries to write these values it gives "crash" and the error "Type Mismatch" appears, can someone help me? Private Sub bt_seguinte_Click() Select...

I created a macro to check if the user name and password are correct when he tries to log in, the code works perfectly but I would like to change it and start using it with the "for each" function, is this possible ? Private Sub bt_seguinte_Click() lb_erro_usuario.Visible = False...

I created a macro that detects if the user has entered invalid characters or if the "Textboxes" are empty, but the program is returning the wrong value, can someone help me? Code: Select Case True Case Trim(tb_morada) = "" And Trim(tb_cod_postal) = "" Or (Not IsNumeric(Len(tb_cod_postal)...

I'm trying to remove a name of a specific file from its directory name, it's not the first time I've done it and I remember using the "Unbound" function last time but instead of the program returning the name to me of the specific file it is returning the number of the field corresponding to the...

I'm creating a "Database" in Excel, for that I created a Form for users to register For this Form I created a procedure to check if the fields contain invalid data or if the textboxes are empty the problem is that even if a specific "Textbox" is not empty, the program displays the error...

I have 2 "variant" variables, one with a value of -32 and another with a value of 22 but when I add them the result is -3222, is it possible to really add 2 variant variables?

I'm trying to perform a calculation in vba but when the program does it the error "Type mismatch" appears because the result is 0, can someone help me?

once in a while when my excel runs this code it crashes and starts in recovery mode, does anyone know what might be happening? Private Sub bt_directorychange_Click() Dim fd As Office.FileDialog 'A variável "fd" irá corresponder á caixa de diálogo Set fd =...

I'm having a problem with the code, my program always works, but sometimes (I don't know why) the variable A2 (only happens with this one) is not passed and takes value 0, because this could be happening? Private Sub cb_Agrid_Click() If Not IsNumeric(in_A2.Value) Or Trim(in_A2.Text) = "" Then...

I'm passing values from one Excel sheet to others, it turns out that the variable P666_2 has the value "xxx.xxxx" but when the value is passed to the other sheet the value is in the format "xxxxxxx,0000", can someone help me solve it this problem? Sheets("Calculation_Sheet").Visible = True...

I would like to make my own "text to speech" in vba, when the user kept the mouse over a button or a textbox I would like the program to play a specific audio created by me, how can I do this?

I'm creating a database in excel, as such I have the users' data and their passwords inserted in the tables (picture), I would like to know if the way I'm checking the credentials is correct because I'm not able to log in with the data I enter even though they correspond to the ones in the...

I'm creating a database in excel, I have 2 forms, one for "login" and one for the user to register", in each form I have 1 textbox for the username and another for the password, when the user enters the password I would like each character entered to be presented in the textbox as a "*" but the...

The language of my keyboard is in Portuguese, it turns out that due to the insertion of commas and dots in my Excel for my program to work I have to change it to English, it is possible to create a macro that when initialized changes the computer keyboard language to English and when the macro...

I created a macro that opens a PDF file, inside that same file the macro uses the "SendKeys" command to select how you want to view the page and then double-click Esc to exit the menu and move the mouse to a certain point in da page, the problem is that when the program executes the second...

the path of my file is declared a variable, but the file doesn't open, can someone help me?