Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: Upon opening worksheet check value is present in userform

    Iíve ran out of time now and away working for one week.

    I was hoping to get this fixed before I went it that was free case.

    I will check upon my return

    I donít have excel on my laptop but...
  2. Re: Upon opening worksheet check value is present in userform

    Hi,
    It is but it just showed up as that due to it being pasted into the post
  3. Re: Upon opening worksheet check value is present in userform

    Hi,

    I already have a code using explicit.

    Here it is below.

    How / what should i now do,please advise thanks.


    Option ExplicitPrivate Sub PostageCustomerDuplicateSearch_Click()
  4. Re: Upon opening worksheet check value is present in userform

    Hi,
    Im getting a bit confused with this.
    I have the code below, did i do it correct ?

    I click on the worksheet.
    I see the I see the msgbox Open Postage User Form.
    If i click Yes or No i see...
  5. Re: Upon opening worksheet check value is present in userform

    Form name is PostageTransferSheet

    I will check this code once back.
    Thanks very much.
  6. Re: Upon opening worksheet check value is present in userform

    It is the name of my combobox on the userform.

    This is where the names are shown after being sorted in column L
  7. Upon opening worksheet check value is present in userform

    Afternoon,

    When i open my worksheet i see a msgbox asking if the userform should be opened.
    Clicking on Yes should only open the form if NameForDateEntryBox.Text has a value in it.

    Below is my...
  8. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    Hi,

    I have a msgbox appear in my original code shown below where once i click OK userform still opens.
    At this point there is no need for it to open if the NO DATA message is shown so im just...
  9. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    Ok
    This works but needs cleaning up / writing correctly + one other thing which i will mention.

    Please take not of red text.


    Private Sub UserForm_Initialize() Dim cl As Range, rng As Range,...
  10. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    Kind of works.

    I have 3 entries in combobox.

    One entry is removed to worksheet.
    I then see two names in combobox.
    I then remove another entry to worksheet.
    Now as opposed to seeing one entry...
  11. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    Ok i thought it was but nevermind.

    Are you able to assist with this please.

    If there is nothing to sort in column L etc then show msgbox when you try to open anthing apart from this error...
  12. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    I am not sure if that was for this joib or another now.
  13. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    MAIT

    I believe you were the member who organised this sort code in the first place.

    Worksheet name POSTAGE
    Customers name are in column B
    On the customers row in column G will either be empty...
  14. Replies
    13
    Views
    232

    Re: Hide combobox entry options please

    DanteAmour i agree with your reply.

    It was going to be a workaround for a problem i have.

    Here is the code below.

    When the combobox has only 1 entry left then i see an error message.
    When i...
  15. Replies
    13
    Views
    232

    Hide combobox entry options please

    Evening,

    I wish to hide two entries in a combobox.
    Please can you advise what options are available.

    The two entries in question must be in the combobox BUT not shown.
    Deleting these two...
  16. Replies
    2
    Views
    72

    Show msgbox when combobox entries = 2

    Evening,

    I have a combobox where i would like to show a msgbox when the entries become only 2 left.
    Please can you advise


    Private Sub UserForm_Initialize()Dim cl As Range
    Dim rng As Range...
  17. Replies
    3
    Views
    94

    Re: Msgbox loop & unable to close msgbox

    That it,

    many thanks
  18. Replies
    3
    Views
    94

    Msgbox loop & unable to close msgbox

    Hi,
    Can you advise please what ive missed in the code below.

    I run the code.
    I see the msg box with the oK button.
    Pressing OK just does nothing & im unable to close the msgbox.



    Option...
  19. Re: If duplicated name is found & next number in sequence

    ok thanks, i will keep an eye on it
  20. Re: If duplicated name is found & next number in sequence

    Hi,
    I did that and it worked fine as you advised, thanks.

    One thing i have noticed a couple of times though is currently because of customers name sorted A-Z that in cell A6 at present is the...
  21. Re: If duplicated name is found & next number in sequence

    Hi,
    can i ask a question please about the code below.



    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Changed As Range, c As Range, DataRange As Range

    Set Changed =...
  22. Replies
    6
    Views
    136

    Re: Apply 001 after customers name

    Morning,
    I see what you are saying.

    You are saying that,
    STEVE MARTIN
    STEVE MARTIN 001
    STEVE MARTIN 002

    Will then become,
    STEVE MARTIN 001
  23. Replies
    6
    Views
    136

    Re: Apply 001 after customers name

    The code I mentioned above should of only changed the names without numbers after.

    So if there was STEVE MARTIN 001 it should have not touched it.

    If there was say STEPHEN. MARTIN then it...
  24. Replies
    6
    Views
    136

    Re: Apply 001 after customers name

    Ive now got this to work.

    Thanks



    Sub InsertNumber001()

    Dim cell As Range
  25. Replies
    6
    Views
    136

    Apply 001 after customers name

    Hi,

    I have a worksheet called POSTAGE.
    There are customers names in column B
    Current range at present is B10:B979

    I would like some help with a basic code where any customer that doesnt have...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4