asc

  1. kelly mort

    Avoid consecutive character input into a textbox

    I have tried to reverse engineer a vba script to produce the code below here which allows for only alphabets and the characters listed. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) With TextBox1 Select Case KeyAscii Case Asc("a") To Asc ("z")...
  2. K

    Sorting with multiple fields, then by a final grouping column

    The title isn't as clear as I'd like but it's the best I can think of. I have data that I need to sort using multiple fields, and then, put keep in grouped pairs. There is an example below: <tbody> ID Group v1 v2 v3 v4 1 1 1 2 1 2 2 3 1 2 3 1 3 1 1 2 2 3 4 2 1 2 3 1 5 4 1 3 1 2 6...
  3. A

    Finding Cell Address Range Value Based On Multiple Criteria

    Hello there, I am trying to find the first and last cell address based on values in other columns. In the table example below, the values in all three cells will be changing from workbook to workbook, hence the need for a conditional selection. <tbody> A B C test asc 2 test asc 4 test...
  4. R

    clean way to loop forwards or backwards via variable

    The below example will not work because of the If ASC = statement; Does not allow you to do this when starting a for loop. Any ideas as to how I could do this without duplicating code twice? In my production code, have many procedures inside the loop and would rather edit them once; if I have...
  5. M

    convert txt to asc

    Hi! i need help:confused: I have a .txt file, how can i convert it to an asc file??? Thanks
  6. U

    Removing hidden Chr within text, Chr63

    I am using Excel 2010 and cleaning up some data and I have two cells that appear the same but when I compare ActiveCell to ActiveCell.Offset(1,0) they do not match. When I broke it down I found the mid string that did not match and I got its value using SndChr = Asc(Mid(ActiveCell.Offset(1...
  7. S

    Macro/VBA to Read ASC file

    Hello, I have been using Excel for a long time now, but I am just starting to learn the benefits of macros/VBA and I am loving it. I was hoping someone could help me with the code to import a .asc file into a workbook. I would like to create a button that the user clicks that asks them what...

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