Question: Private Sub Enroll() Dim code As Long code = TextBox1.Value If 108000000 < code And code < 120000000 Then If TextBox2 = Welcome Then MsgBox

Private Sub Enroll() Dim code As Long code = TextBox1.Value If 108000000 < code And code < 120000000 Then If TextBox2 = "Welcome" Then MsgBox "Welcome." MsgBox "Enroll the classes." Sheet1.Activate Else: MsgBox "The password is wrong." MsgBox "Exit the log-in." End If Unload Me Else TextBox1.Text = "" MsgBox "Please write the id number again." End If End Sub

I wrote the code for VBA. but

there is comfile error: invalid use of Me keyword.

Please help me why it is wrong and fix it to me.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

of 9 Automatic Zoom Actual Size Page Fit Page Width 50% 75% 100% 125% 150% 200% 300% 400% Ch8Ex7 Coding Template Name: Ricky Z NOTE: Your forms will look like these below BUT IN ADDITION will have...

How do I fix the below errors in Visual Basic? BC30491 Expression does not produce a value This error is showing up six times. Below is my code. I have bolded the text and added astericks to the line...

Solver (SOLVER.XLAM) VBAProject (AM FYP.xlsm) -Microsoft Excel Objects Sheet1 (Applicant Inform Sheet2 (Sensitivity Testin Sheet3 (Sheet1) Sheet4 (CF illustrative tal Sheets (Model Points) Sheet6...

How do you make the visual interface using the code thats given. And what names and properties do you give to the buttons and textbox from the code already displayed here : Dim fileext ( 1 To 4 2 )...

If the number of decimal places is omitted in a Format function (ex. FormatCurrency (123.4567)). How many decimal places will display? 0 1 2 As many as there are significant digits in the value Which...

Purpose: This Windows application determines which patients have a systolic blood pressure reading that is considered too high. Program Procedures: In a Windows application, a text file of patient...

1. What will happen after the folling instruction is executed? Dim X as Byte x=260 a) Value of the variable X will be equal 260 b) System will raise Overflow condition 2. Which of the following is a...

Hello, I am running into the following errors while I am attempting to following the solution posted.PdPrint are giving the errors, I tried declaring them as public objects. I've attached images and...

I need the code in visual basic for this project ---------- In my youth, long before personal computers, there was a company called E.S.R., Inc. that satisfied my desire to possess a computing...

2. There is a non-dividend-paying stock with current price $45. There are currently two 4- month European put options on this stock, with strike price $40 and $50, respectively. The current interest...

After four innings, of a cricket match, Bravo's mean score pras 70 . After the fifth inning, his mean score was increased to 72 . (a) What pras his scbre in the fifth inning?

in the tax court what is the diffeerence between a regular decisions and a memorandum decision

Bohemian Manufacturing Company has the following end-of-year balance sheet: Bohemian Manufacturing Company Balance Sheet For the Year Ended on December 31 Assets Liabilities Current Assets: Current...

Discuss how business practices such as outsourcing and offshoring affect business communication. (Objective 1)

The company for which you work has offered you two tickets to a sold-out event (e.g., a concert, an NFL game). Two of your friends know you have the tickets; each wants to be the person you invite to...

Ethics. Picture yourself as the author of the Ask Andy column in your company newsletter. This month, you receive a letter from Edna, who writes, Im tired of all the office politics here. I think...