Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    3
    Views
    60

    Re: WordArt Under (behind) text

    Yes!!! thank you VERY much
  2. Replies
    3
    Views
    60

    WordArt Under (behind) text

    Hi all,

    Is it possible to have WordArt, or picture under entries in work sheet range, for example let say we have invoice data & behind it we can see WordArt saying "COPY" ?

    Thank you in advance
  3. Thread: No Margins

    by Sahak
    Replies
    5
    Views
    62

    Re: No Margins

    Thank you very much
  4. Thread: No Margins

    by Sahak
    Replies
    5
    Views
    62

    Re: No Margins

    Thank you very much for reply. How i understand it depends from printer, not from Excel, correct?
  5. Replies
    3
    Views
    74

    Re: Percentage multiplication and subtraction

    Maybe this

    =C24*0.75-(B7+B11+B15)
    or
    =C24*0.75-B7-B11-B15
    or
    =C24*75/100-(B7+B11+B15)
    or
    =C24*75/100-B7-B11-B15
  6. Thread: No Margins

    by Sahak
    Replies
    5
    Views
    62

    No Margins

    Hi All,

    Is it possible, to have printout in Excel with NO margins (maybe with macro) ?

    Thank you in advance.
  7. Replies
    4
    Views
    173

    Re: Set focus back to seme TexBox

    Thank you Yongle very much.
  8. Replies
    4
    Views
    173

    Re: Set focus back to seme TexBox

    Yes!!! Thank you very much.
  9. Replies
    4
    Views
    173

    Set focus back to seme TexBox

    Hi all,

    On UserForm I have textBox were user should enter school name, I would like, if the name already exists, to get message that the name exists & Focus stays in same TextBox (not move to the...
  10. Re: Get folder path if you know folder name only

    Sorry, I did not quite understand your reply, English is my 2nd language, is what I’m asking not possible?
  11. Re: Get folder path if you know folder name only

    Hi

    Thank you very much for reply. The scenario is this:
    There is a program made by Excel VBA for more than one user & database file located on SERVER, in folder “Invoices_2019“,so any user can...
  12. Get folder path if you know folder name only

    Hi All,

    How with VBA to get folder path if you know folder name only ?
    For example if you know that somewhere in computer there is a folder named “Invoices_2019”
    Thank you in advance
  13. Thread: VBA Formula

    by Sahak
    Replies
    6
    Views
    235

    Re: VBA Formula

    Hi Zinah,

    I'm sorry for late reply, I just came home. I'm happy that I could help you. Your second question also answered correctly & this time by Michael M
  14. Thread: VBA Formula

    by Sahak
    Replies
    6
    Views
    235

    Re: VBA Formula

    Hi Zinah

    Try This


    Sub EnterFormula()
    Range("A1") = "=IF($Y$16 = ""by Loc"", INDIRECT($AC$14), $Z$15)"
    Range("A2").Formula = "=IF($Y$16 = ""by Loc"", IF(ROW(INDIRECT($AC$14)) +...
  15. Replies
    3
    Views
    235

    Re: How to make automated hour calculation (closed)

    You are very welcome.
  16. Re: no blank cell in drop down list - dat validation?

    Hi John,

    Yes, sometimes Excel does unexpected things :)
  17. Re: no blank cell in drop down list - dat validation?

    Hi John,

    Uncheck Ignore Blank
  18. Replies
    3
    Views
    235

    Re: How to make automated hour calculation

    Hi Henceman,

    if
    A1 = 18:00
    B1 = 21:00
    put formula in C1 =A1-TIME(8,30,0)
    put formula in D1 =C1+TIME(8,30,0)
    You will get your answer in C1 & D1
  19. Thread: Excel Queries

    by Sahak
    Replies
    5
    Views
    234

    Re: Excel Queries

    Thank you very much.
  20. Thread: Excel Queries

    by Sahak
    Replies
    5
    Views
    234

    Re: Excel Queries

    Hi sandy666,

    Thank you very much for reply.
    Im week with queries, could you explain how to load tables into PQ Editor, by the way my Excel is 2007.

    Thank you in advance.
  21. Thread: Excel Queries

    by Sahak
    Replies
    5
    Views
    234

    Excel Queries

    Hi All,

    If I have some data (say 1,000 rows & 20 columns) on Sheet1, and some data (say 1500 rows & 12 columns) on Sheet2, how can I make queries ?
    Thank you in advance
  22. Replies
    2
    Views
    153

    Re: Formula on TextBox

    Hi Norie,

    Thank you very much, it works. So, it is not possible with one cell (:
  23. Replies
    2
    Views
    153

    Formula on TextBox

    Hi All,
    To have text on “TextBox” we enter in formula bar, for example
    =$A$1 and on TextBox we will get cell A1’s value.
    Let say in A1 we have telephone # “(123) 456-7890” & we like to have on...
  24. Replies
    11
    Views
    423

    Re: Advanced Filter & ListBox

    Thank you Kamolga very much.
  25. Replies
    11
    Views
    423

    Re: Advanced Filter & ListBox

    Dear Kamolga, I totally confused, please see your private message.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4