Search:

Type: Posts; User: bongobongo

Search: Search took 0.04 seconds.

  1. Re: Excel VBA - Is it possible make a cell comment auto width and height?

    Hi and thanks for your reply!

    Did some more testing after I read your reply and found this:

    If I USE:

    .Shape.TextFrame.AutoSize = True

    and REMOVE these two lines:
  2. [RESOLVED] Excel VBA - Is it possible make a cell comment auto width and height?

    Hi.

    When I insert a cell comment using VBA, is it possible
    to make it auto adjust the width and height according to the content?

    If one comment consist of let say 10 lines and the longest...
  3. Excel - vba - Shorcut Key: Is it possible to override CTRL+DOWN-ARROW ?

    Hi.

    I want a custom macro to be run when the user hit
    CTRL+DOWN-ARROW

    So, yes I want to override the default behaviour of excel on
    CTRL+DOWN-ARROW

    Is that possible?
  4. Re: How VBA change to sheet in workbook on close, without question "Do you want to sa

    Got it now:

    I can use
    ThisWorkbook.Saved = True

    after my code in excel open

    and check against that code before i make any changes in
    Workbook_BeforeClose
  5. Re: How VBA change to sheet in workbook on close, without question "Do you want to sa

    Thanks for the answer.

    That sound like a good idea.

    I could use:

    Saved = True in workbook_open after my initial changes.

    Then in Workbook_BeforeClose I could check if
    the user has made...
  6. [RESOLVED] How VBA change to sheet in workbook on close, without question "Do you want to save"?

    Hi.

    In both Workbook_BeforeClose and Workbook_Open I need to change color index for some cells.

    If the user have not made any changes to the sheet, except for those changes that where done in...
  7. Re: How do I add a Unicode character to Excel cell using VBA?

    Thanks
  8. How createAnObject withinAcell and keep it's size percentage wice to the cell?

    Hi.

    I need to be able to create an object within a cell, and the object should
    adjust it's width and height in relation to the cell width and height.

    I have tried this using Picture and Label...
  9. Solved! How do I change color for individual character within cell comment using VBA?

    Hi.

    I have with VBA inserted one or more lines into a cell comment.

    How do I change the color for the first character in each line using
    VBA, each of the first characters will have different...
  10. How do I add a Unicode character to Excel cell using VBA?

    Hi.

    I'm looking at the charmap and have selected a character within the following fonts: Lucida Sans Unicode

    At bottom of the charmap the following is displayed:

    U+2588: Full block

    (it is...
  11. Re: Excel: How do I insert different colors in same cell?

    Is it possible to create one or more custom attributes for a cell, where each of the custom attribute should be able to store a short text string?
  12. Re: Excel: How do I insert different colors in same cell?

    Well, I'm not able to do that because:

    A cell higher up in the colum are related to the color(s) set for zero, one or more cells further down, in the same column.

    I might be able to do what I...
  13. Re: Excel: How do I insert different colors in same cell?

    Hi.

    I cannot use multiple cells to reprecent one cell, unless I can create multiple
    cells within another cell..... probably not very doable though... :-)

    Pictureboxes and labels.... maybe,...
  14. Excel: How do I insert different colors in same cell?

    Hi

    I need to be able to display one or more colors within a
    cell in Excel.

    Ultimately it would be nice to also be able to put in a number
    within each color in the cell as well.

    (Note: I...
Results 1 to 14 of 14



Click Here to Expand Forum to Full Width