uname

  1. J

    Option Explicit causing compile error

    This code is periodically crashing excel when a user doesn't save a workbook. Sub FillLog(uName) Option Explicit uName = Environ("UserName") Sheets("Values").Cells(10, 43) = uName End Sub I ran the "Compile VBA Project" from the debug menu and it gave me an error or "invalid inside...
  2. kelly mort

    Data-type, case-match and InputBox issue.

    I have this code here and when I call the InputBox only the admin will match. All the others return the else statement. So I used that UCase but still. What is it that I am missing? Option Explicit Private UName As Variant, TheAccount As Variant Sub ActiveInactive () TheAccount =...
  3. A

    getting error 91 when running macro but no error when I debug.

    Hii, I'm getting error code 91 object not set while running this sub. while when I debug and go lie by line by pressing F8 it doesnt show any error and run smooth.Please help. i would be really thankful. Sub systemLogin() Dim objIE As Object Dim uName As String Dim pAss As Variant uName...
  4. V

    list doubled in combo box

    Hi All, Below is my code. After every submit of my record, my user form goes initialize. This makes doubled the items in cmbActivity & cmbTaskStatus.. Any thing on this, which will not double the items in list.. Private Sub UserForm_Initialize() mTimer.TimerOn 10 BtnStart.Enabled = False...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top