+ Reply to Thread
Results 1 to 2 of 2

with i as integer different format for an declared array

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    with i as integer different format for an declared array

    Writing updated values to a database from a listbox selection I am having problems with date formatting. Basically most of the textbox values are text and are needed as text the array below though are the textboxes that are actual date value. How can I add a condition to use a date format version for the numbers listed in the array


    Please Login or Register  to view this content.
    I tried
    Please Login or Register  to view this content.
    But that changes other required numbers that are needed

    My Array = (10,21,24,27,29,31,33,35,37,39,41,43,45)

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: with i as integer different format for an declared array

    Hi,

    Perhaps this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Convert Boolean Array to an Integer Array
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-23-2014, 01:14 AM
  2. [SOLVED] Convert Date/Time array to a integer array
    By bradja in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2013, 03:08 AM
  3. Using an integer as Array Index
    By Pergo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2012, 03:42 PM
  4. [SOLVED] Find the lowest integer in an array
    By publius190 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2012, 01:17 PM
  5. Integer defined array vs variant defined array ..error making assignment to integer
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2011, 01:48 PM
  6. array names declared on the fly
    By GunNam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2010, 10:22 PM
  7. How to reference a public array (declared in module) from a proced
    By Amzee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2005, 05:06 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