click

Hi, I've made a workbook on 1 PC using Office 365 2016, and now when I open the workbook on my laptop (SurfaceBook) I am getting a really strange issue. When I am clicking a cell it is selecting a different cell to what I click. It is not a mouse issue. For example clicking cell A48 is...

Hi I have a userform which has a label as a question and 3 radios buttons as an answer. The form is this http://tinypic.com/r/6gaj2q/9 http://i65.tinypic.com/6gaj2q.jpg When use click on Math button, math cell value will be incremented by 1. Everything is working fine if a user will click on...

I have a table that I have a lot of production numbers in at regular intervals, say 4/hr at 15min intervals. Each 15min interval is in a different row, all in the same column. How do I quickly populate a table where each hour is on a different row, four columns wide? I know the text =C# doen'ts...

Hi All, I normally would not come here, but sadly am now at the deadline and running this as it is does not work. I am trying to get this to auto run on open or just click the Get Report button once to run all three reports f possible. [Private Sub CboReportName_Change() End Sub Private Sub...

the last part in the title of my request here ("WHEN YOU CLICK ON A CELL") is what I am really after... CURRENTLY I have code in my worksheet that when a commandbutton is clicked, it takes all the text within a RANGE OF CELLS ( which is: Range(Cells(370, 9), Cells(rCol, 10)) ) and puts them into...

Morning all, I have an file I open(file defaultsd to cell C2 which Must be filled in.) with a click box in a form. when the workbook opens I can't edit the fields. the cursor is a thin lined cross , when i click it turns to a plus sign then back. when I try to close I get my message to fill in...

Dear All, good morning, I have a spreadsheet and I have added comments. I have - up to now - been able to edit the comments without problem. Today, I have tried to edit the comments but it won't allow me. When I right click / edit comments, the comments box won't open. Could someone advise...

On my pivot table, I click 'change Data source' and click the table range that I need and click OK. I go back to the pivot click refresh, nothing happens, go back to the Change Data Source' and the old Data source is listed. Range - 'Open PO Raw Data'!$A$1:$AB$26160 (old source) range -...

Hi I want to change the background color of a userform when a user click anywhere inside the form. Change the color different from previous one whenever user click on the form. I tried the following code but did not work. Any help would be very much appreciated. Private Sub UserForm_Click()...

I have a sheet and when you click on cell B4 a multipage userform opens. I was able to get the page captions to reflect a particular cell (i.e. Page1 = B4, Page2 = B5...) but they only change once you click on the page. So when the form opens it first says Page1, but when you click it, it...

I have a chart in a sheet that doesn't update when a macro I wrote runs. After if I click on the chart it updates. Any idea what I can do for quick fix.

Hi - is there a simple way of knowing where the Table range is looking at if the file path is long and the file path is not in the same file - when I click in I cant see and then the file path stats changing Thanks

I have Excel 2013. I go to to a workbook. Click on developer tab. I click record macro and store macro in personal macro workbook. A popup says personal macro workbook in the startup folder must stay open for recording. i click ok. Another popup says unable to record. click ok and close the book...

Hi, I would like to fill the blank cells by shifting cells to right. I found the solution "Make sure you only have a single cell selected. Press F5 Click the "Special..." button Select "Blanks" and click OK Right click and select "Delete..." Select the "Shift cells left" option and press OK...

How can I navigate to the second page of a webpage? Suppose I want to go to the second page of the questions webpage on mrexcel: Dim IE As SHDocVw.InternetExplorer Set IE = New SHDocVw.InternetExplorer IE.Visible = True IE.navigate...

Have a bottom in my workbook. I want to identify which macro has been assigned to the bottom. I right click it and say assign macro....however this is not the macro which is assigned to the buttom...

I currently have an Excel sheet with MultiPage userform to add data onto a worksheet. Data has to ability to fill up to 122 columns. I want to make it so that the sheet cannot be edited directly, I want it to be an "Edit Row" button - so the user can click in any (populated) cell in a row...

I'm testing a UserForm that gets user input for a number of items. When testing I click on there'd cross (top right to get back to my VBA UserForm code. This always takes me back to the "Object" view rather than the code. Is there any way to change this behaviour? Not a major problem to click on...

Good Evening- Running excel 2016- not sure why- but excel recently has started a funky method of opening projects. If I double click a workbook saved on my desktop, it opens up excel with no workbook loaded. I then have to go back to the desktop and double click the workbook again to load...