vbpropercase

  1. B

    Overcoming issues with vbProperCase

    So that Users do not have to capitalize the entries made into UserForm TextBoxes, I’ve incorporated these lines of code. ws.Cells(iRow, 1) = StrConv(TextBox1.Text, vbProperCase) ws.Cells(iRow, 2) = StrConv(TextBox2.Text, vbProperCase) ws.Cells(iRow, 3) = StrConv(TextBox2.Text, vbProperCase) & "...
    • Big Lar
    • Thread
    • attendee list strconvtextbox1.text vbpropercase ws.cellsirow
    • Replies: 3
    • Forum: Excel Questions
  2. B

    VBA sort ws without selecting

    My code adds data to worksheet (“Members”) without selecting the worksheet. In order to sort the worksheet I have to select the ws and then select the range. Otherwise, the code sorts the active worksheet. How can I modify my code to sort worksheet ("Members”) without selecting it? Additionally...
    • Big Lar
    • Thread
    • code selecting vbpropercase worksheet ws.cellsirow
    • Replies: 4
    • Forum: Excel Questions
  3. K

    VBA - add special conditions to proper command

    Hi, I currently run a vba script that looks at a column of last names and runs the proper function. While doing so it also looks for names like McDonald and ensures the 'D' is upper case. my current script works perfectly. my new issue is a name such as wagland-mcdonald - my result im getting...

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
Back
Top