show

I have this datepicker that I have placed on a frame in order to hide it and show it in various instances. Now I am using the "mouseMove " event from a parent frame to hide or show the datepicker. It responded fine. The only issue here is that when the datepicker is opened, after hiding the...

Hi all, I have have a code that will copy information from one workbook to the other. I have the Source workbook open, and it will show in VBA editor. When I check out a file (from a program at work) it will be saved in a local checkout folder on my computer and the file opens in Excel...

My fields disappeared in my query after I unchecked the Show box. I don't mean they don't show data view, I mean when I go back to the design view they are all gone. What happened?

=IF(I119="1",E119+J119,0) with this formula, if the value doesn't show up, instead of seeing N/A's how would i make it so I see "-"'s instead?

I know how to conditionally format for duplicates. Is there a way I can format only those text values that show up, say, 4x or more, instead of 2?

I have a table with 47k records on it. Column J has a number of values. I am concerned with the tracking user "jjj222" Column D has Principal. Column E has repayment amount. What I am trying to accomplish: If borrower (column K) has a balance (D-E) with user jjj222 (found in column J), show...

I have created some buttons via Form Control and assigned macros to them. I just noticed that many of them literally disappeared. I closed Excel and then reopened the file, and now the buttons show up. I am glad they are working again, but any idea why they would disappear to begin with?

I have the access settings to show one form through options when Access is opened, but is there a way to show (2) form tabs when access is opened?

Hi all, new to power Query and I need a solution to the above problem. basically I have a list of prices in 1 cell that are separated by a full stop "." E.g. 10990. 10450. 10190. 9990 And so on up to a max of 19 changes. I want to reverse these to show the below 9990. 10190. 10450. 10990...

Hi Everyone, I create invoices in several currencys and I constantly have to change the formating of column J, K, & N which i can sometimes forget. however ever company has is currency stated in cell B2 of the sheet. so is there an easy way to format the cell to show the correct currancy? i.e...

Does anyone know why I cannot get the following code to show the digits after the decimal point in my label caption? Budget is the label name. Everything works great except for the fact that I can't get it to display the cents. 1900 displays as "$1,900." 1900.00 displays as "$1,900." No...

hi, i cant find it? i pressed f4 and it's not showing. also, before it disappeared, it was "free flowing" and not locked as it usually is at the bottom left corner? how do i lock it? (first i need for it to show up, my first issue)

Dear Pros, Please help me with 1 function that can determine whether there is any gap by item name. example1: For itemA, "Cell E1" will show "No Gap" if b1,c1,d1 all are"No Gap" example2: For itemA, "Cell E1" will show "Gap to 1st" when b1 ="Gap to 1st" while C1 and D1 ="No Gap" example3...

Hello, I thought I had this worked out. I am trying to get the points in cell C4 to show up in z3 IF "H4-20"or "J4-14" which in this case is H4-20, to show up in cell "Z3" =IF(H4>J4,C4,O4) This formula is located in Cell "Z3" But without a score put in h4 or J4 it will show "O4'S 90" in...

hi guys, i would like to make two buttons, one at B1 and the second at C1. if you press B1 button must show number 1 at A1 or if you press C1 button should show 2 at A1. The second issue is that i would like to have these buttons in columns because am interesting to have data in A1:A30. thanks...

Hi, I would like to show a threaded comment (with notes it is straightforward, we put them on 'visible=true') when activating a sheet. Is there a line of code to show those threaded comments ? I noticed there is a "show comments" in review tab but recording macro does not help. Even if I add...

Hello -looking for some help. Thanks in advance! A1 = $12.55 B1 - If A1 has any cents (.01 - .99), show that full # or $12.55. If there are no cents (i.e. 12.00), then show only the $, not the cents or $12 Example 1 A1 = $12.55 B1 = $12.55 Example 2 A1 = $12.00 B1 = $12

I have a pivot table where I'm trying to find all the losses. So I'm seeing all the values, where 80% are positive, but I only care about the negative ones. Is there a way to show only negative values? Please note, this isn't just in the grand total column - I want this in the entire grid. For...

Hi All, Can any one tell me how to show the hdd serial number in a cell IE: "P1" Thankyou

Can anyone show me how I can delete all the rows after the last one found in column C with the criteria 'Not Available'?