attendee

  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. C

    Using "Fuzzy Lookup" to compare 2 columns and return cell contents of adjacent cell to matched record... on Office on OS X

    I know there are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I have 3 cols of data: Col A = My accounts Col B = Each account's point of contact Col C = Attendee list I want to know if an account I own in col A is in the attendee list in col C but there...
  3. C

    Using "Fuzzy Lookup" to compare 2 columns... on Office for MAC

    There are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I am trying to: I have 2 lists: a Lead List of companies and an event Attendee List I want to compare these lists but there will be spelling inconsistencies between the 2 lists (e.g. - Coca Cola -vs- The...

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