Posts by xlite

    Re: Combo Boxes


    hi Z,


    first of all i don't think you can multiselect a combobox,
    you can achieve that with a listbox


    in VBE, place a listbox on a userform and set it in the Properties > Multiselect >
    1-MulltiSelectMulti


    double click the userform and place this module:

    Code
    Private Sub UserForm_Initialize()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        With Me.ListBox1
            .AddItem ws.Name
        End With
    Next
    End Sub


    hope this helps

    Re: Right-click menu when clicking on Chart elements


    hi m,


    when you created the right click menu, most probably you used:

    Code
    application.commandbars("Cell").controls.add......


    this works only in cells
    in charts you should use:

    Code
    application.commandbars("object/plot").controls.add......


    or

    Code
    application.commandbars("plot area").controls.add......


    can't remember which one, pls try it out


    so u should have the menu ob both cell and chart commandbars


    hth

    hi guys,


    i need to find the nearest result,
    for example if i have 230 i'll get B
    or if i have 460 the answer would be E


    100 A
    200 B
    300 C
    400 D
    500 E


    can anyone suggest a formula for this?
    any help is appreciated, thanks in advance :smile:

    Re: Code To Write Code For Workbook Open Event


    hi Kj,


    i modified Chip Pearson's code a litte to suit yours
    see his website here:
    http://www.cpearson.com/excel/vbe.htm

    Quote

    Before using these procedures, you'll need to set a reference in VBA to the VBA Extensibility library



    hth

    Re: Default Addin Location?


    Quote from mtlay



    i see you still dont have this code i suggested earlier in ThisWorkbook module:

    Code
    Private Sub Workbook_Open() 
        MenuCommand 
    End Sub


    why dont you give it a try?

    Re: Automatically Update Master Worksheet From Departmental Worksheets


    Quote from CBishop

    The approach you use in that example file could work if it would clear the master sheet before adding data; but as is, it would make hundreds of duplicate entries each time it's run.


    yup, you're right
    i've included a line to clear the data in the Master List
    and adapted the code to yours


    just something i don't understand; is col A left empty?

    Re: Inventory Tracking


    Quote from lioncourt

    is there a way to make vlookup non-alphabetical


    i believe Vlookup works for numbers, aplphabets or combination of those


    as long as what you look for is exactly the same as the source data.


    i notice that yr inventory list reads 3/4 ply instead of 3/4" PLY
    this of course won't work :p

    Re: Default Addin Location?


    ah got it


    place this code in ThisWorkbook module:

    Code
    Private Sub Workbook_Open()
    MenuCommand
    End Sub


    this will add the menu each time the excel opens :)

    Re: Inventory Tracking


    creating inventories can be very tricky, especially if you are not familiar with all the items.


    what i can suggest is to use Vlookup formulas :)

    Re: Convert Number To Hours & Minutes


    Quote from Timbo

    A colleague has columns of data that when summed are all wrong i.e. 8.65 instead of 9 Hours 5 minutes.


    hi Timbo,


    what you should do is correct the mistake yr colleague did before summing them up


    try this formula to convert them to time
    then you should be able to get the correct sum:


    =SUBSTITUTE(A1,".",":")


    where A1 is the wrong entry.


    hth

    Re: Default Addin Location?


    Quote from mtlay

    The addin has a dropo down "Data" menu item associated with it. It has no optional submenu items. It's more of a menu function.


    sorry i still can't get it,
    is it possible if you post the menu code here?
    (pls remember to use the code tags using the # icon)
    thanks