Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Auto populate a demand form from quanity list

    Hello,

    I have a workbook which each sheet has its own list of items for a stock check. On sheet 2 I have a form which is a company made form to request missing items.

    With this I would like a...
  2. Re: Only make a code run from an approved user list.

    Fluff

    Works like a dream! Many Thanks.
  3. Only make a code run from an approved user list.

    Hello,
    So i have a sheet when someone clicks a button and it shows the relevant hidden cells.

    However i would like to restrict this to only approved people to have access to run this code.
    ...
  4. Re: Code to change date to 1 years time by using a pro-word

    Thank you MickG

    I am thinking of making this code better by having Day, Week, Month, Year. Would this be easier to change?
  5. Re: Code to change date to 1 years time by using a pro-word

    @CalcSux78

    Awesome does the job. However after it completes the date. I get Runtime Error 13. Type Mismatch on "i = CLng(Left(cel.Value, Len(cel.Value) - 1))"
  6. Code to change date to 1 years time by using a pro-word

    Hello,

    I would like some help with a bit of code.

    What I have is some dates in cells H3:H. I would like toenter in the word "1Y" in the next cell I3:I and it will add 1 Yearto the date in H3...
  7. Re: Environ("UserName") changes from "User123" to "usera123"

    Could you please elaborate or give me an example please?
  8. Environ("UserName") changes from "User123" to "usera123"

    Hello,
    I have a code which unlocks a sheet based on usernames.


    I've noticed that the code sometimes doesn't work because our Environ("UserName") changes from a Capital letter at the start to...
  9. Re: Replace code to be able to run on anyday of the week.

    gallen

    Thank you, Works great! Plus its faster than my previous code. Thank you for cleaning up my code too. I'm not the best and quite a messy person when it comes to code.
  10. Re: Replace code to be able to run on anyday of the week.

    No worries,

    Ill try it now, ill post the whole code to give you more of an insite.


    Public Sub HideMyCells1() 'Monday Dim objWord As Object
    Dim objDoc As Object
    Dim Cell As Range...
  11. Re: Replace code to be able to run on anyday of the week.

    gallen & tyija1995,

    Thank you for your response. Sorry it's difficult to explain.

    In cells J10-NJ10 i have dates. 01/01/19 - 31/12/19. I need the code to search for the monday of this current...
  12. Replace code to be able to run on anyday of the week.

    Hello, so I have a large code which runs a report on dates. I have this code 5 times with just an "offset" +0 +1, +2 +3 +4 (Simulating Monday, Tuesday, Wednesday, Thursday, Friday.)
    This code at the...
  13. Re: Cell to only allow certain text strings.

    Awesome works like a charm.

    Anyway I can get it so it's not case sensitive? :)
  14. Cell to only allow certain text strings.

    Hello,

    I need help with a code that will only allow certain text strings in the cell. So like data validation however not so restricted.
    For example restrict the cell to have these:
    Holiday...
  15. Re: Show error message when word in text string isn't in approved list.

    Dante,

    You're the best! Thank you!
  16. Re: Show error message when word in text string isn't in approved list.

    Dante,

    Awesome works great. Don't suppose you could show me how to tweek it to not display the message if i double click the cell and its an empty cell?
  17. Show error message when word in text string isn't in approved list.

    Hello, i would like a code that will show when a user enters a string of text and there isn't a word in that string that doesn't meet the approved list.

    Approved list:
    'World'
    'Planet'
    'Globe'...
  18. Re: Data Validation - Text in cell which contains words.

    @garden Utopia,

    Thanks for the reply! I have actually tried this however its a very fluid document. For instance The word "Holiday" is the pro-word here which gets coloured. I use the document as...
  19. Re: Data Validation - Text in cell which contains words.

    rpaulson

    Thanks for your comment, i know that as i have that selected already. however i would like a data validation to stop people entering anything and limit it to what words i would like that...
  20. Data Validation - Text in cell which contains words.

    Hello,

    I would like some sort of data validation, or vba code to stop people entering the wrong information.

    I have a list of words which gets coloured in conditional formatting. Sometimes...
  21. VBA to search list and apply value to different list

    Hello, wonder if you can help me.

    I have a list comprising of:

    <tbody>
    ID
    Title
    Name
    Dept
  22. Re: Simplify and shorten my code to search by colour

    Perfection. Thank you Mr Fluff
  23. Re: Simplify and shorten my code to search by colour

    Just got a Compile Error


    End With

    End with without with
  24. Simplify and shorten my code to search by colour

    Hello,

    So I have a code which upon running it searches set cells for the colour and then counts that colour. As i need this to run over a large amount of data i don't want to have a huge copy and...
  25. Re: Offset from active cell until given range

    Awesome thank you! I can confirm that this is exactly what i needed. big up the Fluff and Norie.
Results 1 to 25 of 79
Page 1 of 4 1 2 3 4