Results 1 to 8 of 8

Thread: split a code

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    208

    split a code

    hi there, i'm new to vb programming. i'm using vb macro in excel to split this code 15110-ACN-01 which is in a cell in my wooksheet. therefore when i press a command button then code have to be seperated as follows
    15 = Area
    151 = subarea
    15110 = system
    ACN = air con
    01 = sequential number.

    how you guys know to do that, please.
    thank you
    Last edited by Prav; Nov 9th, 2005 at 09:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width