+ Reply to Thread
Results 1 to 5 of 5

How can I to retitle my case VBA to include extra text information???

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    How can I to retitle my case VBA to include extra text information???

    Hi,

    I need to introduce another variable into some case VBA and I'd like it to include the word "crank"
    Dose anybody know how I can achieve this? It's the line of code thats "Case 127c." , which is incorrect but serves as a director.
    The reason being there are two products that are labelled as 127 but one of them is traight, the other curved
    Many Thanks



    Please Login or Register  to view this content.
    Last edited by bralew; 10-12-2016 at 07:06 AM.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How can I to retitle my case VBA to include extra text information???

    Change this line:
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How can I to retitle my case VBA to include extra text information???

    Still got this Ol?
    Attached Images Attached Images

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How can I to retitle my case VBA to include extra text information???

    Oh yeah - change that to:
    Please Login or Register  to view this content.
    It's a string, not a number...

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How can I to retitle my case VBA to include extra text information???

    Doh!!! Thanks very much - brilliant as ever

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Array to include extra column
    By Kmartin83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2015, 04:00 AM
  2. [SOLVED] Modify Macro Code to include an extra Pop Up with different trigger
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2014, 11:49 AM
  3. Need to modify formula to include extra condition
    By LeithKaouas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2014, 08:35 AM
  4. [SOLVED] Editing a Macro to include multiple rows and include text formatting for leading zeros
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2014, 09:50 AM
  5. [SOLVED] Adding extra case to macro...
    By mmcgrail in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-03-2013, 05:36 PM
  6. Vba code for remove extra full stops, and make sentence case.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2013, 04:04 AM
  7. Deleting same items even if I include extra rows
    By amartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2013, 01:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1