Search results

Hello! Sorry, I didnt reply earlier as I was down with a nasty flu last week :( I had tried putting the code into the module but nothing is happening. I had also downloaded your sample file, and tried to entering new category, but nothing happened either - even when i saved the data and...

Hi, I have an excel file which I would like to create a macro / code to create new worksheet based on cell value for the Column A. Attached is my sample file. https://dl.dropboxusercontent.com/u/172679/Book%201.xls The worksheet is the Master worksheet which I will update regularly...

Dear SirJB7 and Hui and jeffreyweir Many thanks for your replies. The main reason I turn off the calculation for this worksheet is because of the huge amount of data and formulas in this worksheet, which means when I copied and paste data, Excel takes some time to re-calculate the cells...

Hi, Below is a VBA code that I have to stop calculation for Worksheet A. Option Explicit Private Sub Worksheet_Activate() Application.Calculation = xlCalculationManual End Sub Private Sub Worksheet_Deactivate() Application.Calculation = xlCalculationAutomatic End Sub However, I...

Dear SirJB7 Thanks! Its great! But I found that if I paste the values into the Sheet 1, the popup won't activate. Do I have to enter the data one by one. Cheers! Zhen

Opps again, I didnt realise that the access was locked. I had just granted public access. Pls let me know again if you are not able to access the file. Thanks SirJB7 for letting me know about this :) Cheers, Zhen

Hi Hui, Thanks again for your reply! Pls see below link. https://docs.google.com/file/d/0B79KDA8KYvN7cUFQWUhkWHFfeTQ/edit?usp=sharing What I need is for a popup to show up when I enter any value from Sheet 2 Column A. The Popup message will show the adjacent value for the corresponding...

Thanks Hui for your reply. I thought that a pop-up will attract my attention more. Furthermore, I am not able to use a Index/Match formula in a adjacent cell as I have to input other data in the adjacent cell. The Index/Match formula will have to be input a cell which will be away from the...

Hi all, I want to create a pop up that will show up when I enter a value in a cell that corresponds to another cell in another worksheet. I will have 2 columns of values in Sheet 2. For example in Sheet 2, cell A1 is Apples and cell B1 is "To buy from Vendor A". When I enter data in...