edit

hello, Can you help me to identify and solve my problem? I have multiple textbox in userform and all of it was Vlookup to Combobox1. I arrange the format of each Textbox according to number, percentage and date. it was all good but when i want to edit or change the value in textbox, it doesn't...

Hello, I have some code that copies and pastes data from cells in certain workbooks into columns in the main workbook. When running this, the ary 0-3 seem to be mixed in order when pasted and come up with some blanks when there are none. I do not have the code available at the moment but I...

I need to edit just 2 of them, and the file is large so its too much time until it loads. Is is possible to open just the one I want to edit? Have a nice day!

Hi Everyone, I have this macro that resets the fonts on every sheet to black it works great but I've just realised I don't want it to change the Dashboard sheets, Is there a way to edit it (or start again if you have better ideas) so that it runs on all sheets unless they contain the word...

Hi team. Please note I have one ms access database table from there I fulled the data in a excel userform after data I want edit the particular cell data. I have created the all coding for export data from access to excel userform. While I edit the data in text box and I try to submit on that...

Hi I found it is hard to edit a formula in the Conditional Formatting -->New Rule-->Using Formula, box When I click inside the box and then click any cell excel will enter the absoult value i.e $A$1 let say I wrote this formula =$A$1 >10 Later if i go to that box and to edit something for...

Hello Everyone, I was trying to prepare a Report of a Hotel business I work under. I have a report that tracks the records of each division & the focus is very high on the comments provided. Attached Excel file has an example of how the report looks. Column "C" has comments that is populated...

​When I launch Excel 2016, As soon as I edit a cell and press Enter, Excel Freezes. I have to shut it down via the Task Manager. It does not freeze when in Safe Mode. Thanks in advance for any advice, Tamir

Hello all! I need help with a macro to password protect and unprotect several sheets at once - and prompt the user when an incorrect password is given. Also, when each sheet is protected I would like user only to have access to 1. group/ungroup, 2. edit column widths, 3. access unlocked cell...

Hi all, I am now working on a data collection sheet and would need some helps from experts here, please kindly gives some advises. I create a worksheet and want others to fill in structure design parameters (length, width, distance between two objects, etc). To better explain where I am...

Re: Locked cells are still editable even though not in "Allow user to edit ranges"-range. I have same issue. I tried many times to Format cells > Protection > Check "Locked" box, but still allow me to edit. I want to ... A) Password protect ranges $A:$I, $O:$P, and $J$1:$N$2 so only I can...

My file has several hundred Named Ranges ("NR") that I'm constantly using in formulas / changing. Whenever I want to edit something, I first need to look up just what cell range a particular NR refers to (so I can either change it, or edit the formula accordingly.) Currently I have to open the...

I have some older workbboks which I am attempting to open in Excel 2016, but open in 'Protected View' with a message 'Office has detected a problem with this file. Editing may harm yourcomputer... When I click on Excel 2016 Help, the following message appears: Exit Protected View and edit when...

Hello, I am working on a big document. I got a formula that helps me with one column, but I am wondering if I can make this more user-friendly. This is the formula =IF(O7="","",IF(O6="","",IF(O7=O6,"","ERROR"))) I am wondering if there is a way if I edit a cell, let say b2 that the Bold O will...

Hello all I am new to Microsoft Access and would like to ask a question I have a calculated field which looks at a field called "Total Cost" and divides this by 6 to get the correct VAT value I sometimes want to edit this field if the product has a reduced or no VAT charge Is there a way to...

Hi, I have a file which is located on an internal network. The file needs to be editable at one person at a time. Whoever opens the file first, will be able to edit. Anyone opening after this should be notified that the file is locked due to another user having it open. They will then be...

Good Morning, I posted a thread about IF(OR and unfortunately, the site time's you out very quickly. I didn't realize that would happen and when I tried to submit my full post it ended up posting half of what I wrote. I went back and replied to my own post with the remaining information but now...

plz look into the sample file everything is mentioned in my data go to each row search for highlighted cell if yes then edit row as per given condition in the sample file and if not then simply copy and paste that row don't do anything with that row see the sample file...

Hello, appreciate if somebody can help to resolve this issue it's too much annoying. I have install office 365 2016 and excel is not showing the formula tip small bar like if you edit cell and type =if( then I should see small tip if true or false help its not coming in.