1. P

    Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    Hi there! I have a program that I'm trying to write that displays a date in a cell based on whether a user clicks on a specific cell. Here are a few notes: The date is formatted as YYYMMDD A4 - Contains the first half of the date (ex YYYYMM) M4 - Displays the final date in YYMMMDD format F/G5...
  2. D

    Automating "Find"

    Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...
  3. L

    using control form checkbox in excel

    Hi I want to ask a question to the user and give 3 choices answers. Q) What is the color of the sky? [x] blue [] red [] green C1 = correct If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following =if(B1=true, "Correct", " wrong")...
  4. A

    Navigate and getting data from website

    Hi All, I am looking for VBA code where following steps areperformed: Open website Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...
  5. W

    Give error/msgboxbox if cell hasent had any values for x times when clicking a button

    Hi. Is there a good way to make it so that if i click a button, the code will check if a spesific cell has had any values in the last 10 times (10 is just an example), and if it hasent, a error message /msgbox will appear? Example. Lets say A1 is the cell i want to check, and a button with...
  6. R

    VBA IE to click on button inside a table

    <table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody><tr> <td style="width: 1%;"> <img alt="" src="/an/919858511/p/Ariba/hdr_Ariba_Discovery_2x.png" height="30" border="0"> </td> <td style="padding:4px 20px 0px...
  7. B

    Posting Pivot Table to Outlook

    Good evening, I'm posting a long Pivot Table from Excel to Outlook. I copy the Pivot table in Excel and go to Outlook and click on Paste, then click Paste Special, then I select Microsoft Excel Worksheet Object, then Ok. Only half of the Pivot Table is posted to Outlook. Help, what am I doing...
  8. N

    Enable / Disable Shapes

    Hi All, I have a excel template where I have 8 shapes created as button and assigned a macro to each shape. Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro. For example: I have a shapes with names Login and Logout. When the excel is...
  9. M

    Ignore right mouse click on form control

    Hi gurus in the sky I use form control buttons to make life easy for my users. I want to disable a right click totally. I have discovered how to disable the "cut, copy, paste etc" menu by pasting into ThisWorkbook Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target...
  10. D

    Empty textbox needs text

    I have a regular textbox (Shape, not an active x textbox) that needs to have the text "Please type notes here" if it doesn't have anything in it. I also need the text to disappear when you click in it so it is ready to type into. Could someone help me with the vba code please?
  11. TAPS_MikeDion

    Quick stupid question about "Sub ComboBox1_Click()"

    Since I'm not that well versed in VBA, unlike most on this forum, I was hoping someone could answer a quick question regarding "Sub ComboBox1_Click()". I thought this was a mouse click event, but as I seem to be finding out, it is also a key click event. Is this correct? I'm wondering...
  12. M

    Power Query

    Hello I have 5 files. Each with 5 worksheets. For each file am trying to consolidate 5 work sheets into one file using Power Query - so I land up with 5 files that each have one worksheet. Worksheet names are AUG_DATA, SEP_DATA, OCT_DATA, NOV_DATA, DEC_DATA. I am trying to consolidate 5...
  13. P

    Lock listbox after CLICK event

    I have a listbox with code that runs after user makes a selection (clicks item). It's a Form Control (vs. ActiveX type). Right now, while the code runs (takes about 5 seconds to complete), user can immediately click another item on list and listbox selection changes (though click event doesn't...
  14. danhendo888

    SUMIFS multiple criteria cannot reference to a cell?!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more countries) =sum(sumifs(B2:B4,{ If I try to click on the cell to reference it, Excel doesn't let us...
  15. B

    Excel Recording a macro

    Ok guys i know the short cut for starting and stopping a recording macro is Alt+T+M+R. My problem is im wanting a macro that will insert a new Row in my table, in form view. (Select anywhere on the table, click on insert at the top ribbon, then click on "Form" on the top right ribbion, then...
  16. M

    Excel 365 Advanced Filtering

    I use this on a number of large files (in 2003 compatibility mode because it is much faster) and when I click Data - Advanced it always comes up with the "Filter the list in place" and every time I must click "Copy to another location" before OK. Is there any way to make Copy to another...
  17. T

    Personal.xlsb visible but not opening.

    Hi all. I hope you can help me as I am having a bad, bad day I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared. The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a...
  18. K

    Data Entry Dilemma

    I have two columns that the user needs to update. One column is a checkbox (actually a wingding font) and the other is a cell with free data. I want them to be able to double click on the checkbox cell but not enter any data. I want them to be able to click on free data cell and enter data. I...
  19. P

    Insert a new row between two two adjacent row from a 600 rows

    Hi, Is there a quicker way of insert a new row between two adjacent rows of a 600 rows speadsheet? At present we are using click on Ctrl + highlight the row one by one and click on insert? thanks, Peter
  20. C

    How to reference an active ActiveX control?

    Hi everybody, I'm writing an 'on_click' event for one of my ActiveX labels. But how do I reference itself in the code? I need to derive the label's name when I click on it. Is there a way on how to do it? thanks...

Some videos you may like

This Week's Hot Topics