Search:

Type: Posts; User: Lexje; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. excel 365 for mac - how to ignore @ sign - autoformatting

    Hi MrExcellers,

    I use a xls sheet as a help for keeping track of website user login and pwd's.
    I know this isn't really best practice, but up to now it's still my most convenient solution.
    Pwd's...
  2. xls application for iOS that allows local storage or dropbox storage?

    Hi Excellers!

    Best wishes for 2019!!

    Is it possible to save Excel spreadsheets to local storage or to attached storage (lightning to usb adapter)? Any solution?

    It seems Excel for iOS forces...
  3. printing list of linked receipts - to single PDF - HOWTO?

    Hi,
    Each month I download a csv overview of creditcard expenditures and save it as an xls file.
    On each line I add the word "link" in column K.
    I then add a link to the receipt. I am on a mac....
  4. Replies
    4
    Views
    269

    Re: Using date condition & array - HOWTO?

    Thanks again for sharing
  5. Replies
    4
    Views
    269

    Re: Using date condition & array - HOWTO?

    p45cal,

    Super! Thanks a lot! Works a treat ;)
    Btw, how do you do the reverse math? Just copy over the html from the post, reapply the range names & paste or adjust the formula(s)?
    Or is there...
  6. Replies
    4
    Views
    269

    Using date condition & array - HOWTO?

    Hi all,

    I'm trying to conditionally sum Total_Amount per Supplier, per month. Column A has the dates (Western EU settings). So all invoices should be summed per month.

    What's wrong with my Date...
  7. Replies
    1
    Views
    987

    Update on HTMLMaker

    Hi all,

    I've been away for a long time, and am delving into Excel again.
    It seems there's a lot of new HTML maker lookalikes...
    Could someone point me to a/the up-to-date way to get something...
  8. Replies
    2
    Views
    331

    Conditional hide ROWS - HOWTO?

    Hi Everybody,

    I'm using a fairly simple IF clause to filter a range and copy the result to another sheet.
    Here's the formula:

    =IF($'Fiche NL'.$H80="X";$'Fiche NL'.$C80;"")

    Source sheet is...
  9. Re: Do PROPER case update, while pasting array, HOWTO?

    Thanks a lot guys!!
    This forrum really ROCKS!!!
    Thanks a lot for the precious help :-)

    Erwin
  10. Re: Do PROPER case update, while pasting array, HOWTO?

    Thanks mdusoe!
    Any way to do this while storing content in the array?
    I ask this, because the array content is also used to fill a listbox.

    Thanks a lot for your help!!

    Erwin
  11. Do PROPER case update, while pasting array, HOWTO?

    Hi Everybody,

    I'm working with an array as follows:



    Dim cellRefs() As Variant
    'Code to make a selection

    I = 1
  12. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    Here's my initialize code;
    By add, I mean that I have copy/pasted the relevant lines at the bottom of the initialize code.



    Sub frmCountry_Tab_Initialize()
    cboYear.Value = ""
    ...
  13. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    When I play around with the shape of the listbox on the userform, indeed the scrollbars react; I even have two scrollbars. But to have only one at the righthand side (Andrew) I have to make it only 2...
  14. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    Norie,

    I appreciate your comments, but:
    I have tremendously positive reaction on this forum, therefore, will also try to help wherever, whenever possible...
    I have experienced however that...
  15. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    Hi Norie, thanks for hopping in;
    I've tried several things, also on a separate test workbook.



    Private Sub MultiPage1_Change()
    With frmCountry_Tab.MultiPage1.Pages(2).lst_Years
    With...
  16. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    But I do see where you're heading.
    The listbox will sit on the third page of a multipage userform.
    Should I opt for the MultiPage Change event or ?

    Thanks
  17. Replies
    9
    Views
    572

    Re: Listbox fillcode?where to put?

    I'm following an example of J-Walk's book.
    I haven't opened a code pane by clicking anywhere. I've just opened the userform code pane.
    My idea was the listbox should be filled when initializing...
  18. Replies
    2
    Views
    422

    Control Listbox scrollbar position, HOWTO?

    Hi Folks,

    When I create a listbox and fill it with some addItems, the listbox automatically shows a scrollbar. This is positioned horizontally at the bottom of the listbox, however.

    What...
  19. Replies
    9
    Views
    572

    Listbox fillcode?where to put?

    Hi Everybody!

    I'm trying to fill a listbox that sits on a userform, via code.
    If I put the code in the userform, it doesn't pick up the additem.
    When I put the code in a module, it's allright.
    ...
  20. Replies
    1
    Views
    316

    Listbox question, IDEAS?

    Hi Folks,

    This is an odd on, probably not undoable, but I have no clue where to start, so ANY suggestions WELCOME!!

    Here goes the description:

    I have 10 sheets in a workbook. They contain...
  21. Replies
    2
    Views
    343

    Re: =INDIRECT("Country_"&$B$2&"!"

    Oaktree, thanks for hopping in!!

    I tried your formula, but it wouldn't work. It doesn't give me an error, but just shows all blanks.

    But, more important, is that my sole purpose was not...
  22. Replies
    2
    Views
    314

    renaming workbook, HOWTO update references?

    Hi everybody!

    I have a workbook containing a lot of names, the workbook has some 30 odd sheets.
    How can we change the names related to the name of the workbook, so that we can rename the workbook...
  23. Re: copy cell content to other sheet if not empty, HOWTO?

    Andrew, thanks a lot!
    That's exactly it, clear and simple!

    One more question,
    How do I go about to run this code without activating the source sheet?
    Can this be done?

    If I run this code...
  24. copy cell content to other sheet if not empty, HOWTO?

    Hi Everybody,

    I am looking for code to copy the contents of a range of cells to an equal cell range on another sheet, and do this while the original cel is not empty.

    Example:
    ...
  25. Replies
    2
    Views
    343

    =INDIRECT("Country_"&$B$2&"!"&am

    Hi Folks,

    I got this formula:
    =INDIRECT("Country_"&$B$2&"!"&CELL("address";A5))

    $B$2 = linked cell from a drop downlist, will contain years from 1999:2009
    So, basically the formula will look...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4