Forum Widgets
Latest Discussions
VBA Code for List Box Change
Hello, I'm having issue trying to setup an Excel worksheet, used as a form. Line 8 (J8, which I named the cell Question1) has a list box that is either "Please Select", "Yes", or "No". When there is a change I would like VBA code ran that deals with the selection made. If "Yes" then hide the next question, which is line 10. If the selection is "No" then just go to the next question. In the VBA editor I have top part of the below screenshot. It calls a macro, which is the second part of the below screenshot. When I choose Yes or No from the first question nothing happens besides the cell changing from Please Select to Yes or No (depending on what I change it to). What am I doing incorrectly? Thanks.mzeller1776Apr 23, 2025Copper Contributor5Views0likes1CommentLook Up for multiple sheets?
I wonder if someone would be so kind as to help me with a little problem... I have 12 different workbooks, one for each store, for labour and sales forecasting. On each workbook there are a few different sheets - one for each period and then a final sheet which shows the total for each week and period, giving a quarterly summary. The only problem with this is when I want to review these I have to open individually 12 different workbooks. Is there a way that I can create a new workbook, which shows the 'Quarterly Summary' page for each store. I initially thought a look up formula, but I think this only applies to particular cells and not an entire sheets? Thanks in advance!jmcintosApr 23, 2025Copper Contributor33Views0likes3CommentsComands not visible under some tabs unless I select arrow
The Alignment tab does not display the various commands like wrap text unless I select the arrow under alignment. I found that I am supposed to have a “Ribbon Display Options” arrow in the upper right corner of Excel, but I do not have this arrow. How do I restore this arrow? This is also true of the Number tab.8104108795Apr 23, 2025Copper Contributor52Views0likes9CommentsScroll Bar not showing arrows
I noticed something new and can't seem to fix it. I've added a scroll bar (form control, NOT Active X). For some strange reason the little arrows that are usually part of a scroll bar are not visible. Is this new or is there a way to get them to show? I've tried widening and resizing the scroll bar but nothing works. The scroll itself works fine, but visually it's missing the arrows (if that makes sense?) Thanks.SolvedStefExceleratesApr 23, 2025Copper Contributor14KViews2likes9CommentsCharts- doubt_1
Dear Experts, I have a Data as below , in worksheet named "Data" and need to create charts as in Worksheets "Chart-1" and "Chart-2", Could you please help share on how to do that, I tried Pivot, then Scatter-plot can't be used, is there some limitation? Br, Anupamanupambit1797Apr 23, 2025Steel Contributor31Views0likes7CommentsExcel Web App - freeze BOTH first row and first column AT THE SAME TIME
RE: MS Excel WEB APP Can someone tell me the secret to freezing at the same time, together, simultaneously the first row and first column in an MS Excel Web App spreadsheet. At this time I can only lock one at a time. I find it hard to believe that you cannot lock both (rows and columns) at the same time on Excel Web App version. Does this mean that no one builds large spreadsheet +50 rows long and +20 columns wide? I am getting a run around from Microsoft to get an answer to a simple and reasonable setting.RHA1705Apr 23, 2025Copper Contributor133KViews2likes14CommentsStamp Duty Calculation
Hello, I have a SUMPRODUCT formula to calculate stamp duty in the UK below where F2 = the purchase price of a property. =SUMPRODUCT(--(F2>{0;250000;925000;1500000}),(F2-{0;250000;925000;1500000}), {0.03;0.05;0.05;0.02}) I want to edit this formula so that if F2 is less than 40000 then the stamp duty = £0 regardless of the above formula. Can anyone assist me please? Thanks, PatSolvedPat_Burrows1970Apr 23, 2025Copper Contributor25KViews0likes12CommentsUtilizing Excel's turing capabilities to create Conway's 'Game of Life'
The Background It's been said with Lambda (and LET and a wealth of functions in 365) Excel has become 'turing-complete'. To quote the article linked below: "You can now, in principle, write any computation in the Excel formula language." https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The Challenge I thought it would be fun to create Conway's 'Game of Life' in Excel 365 to see how far I could push things. Conway's Game of Life - Wikipedia The rules are simple: A 'cell' has up to 8 adjacent cells (less if the cell is on the edge of the board). A 'neighbor' is a cell with a 1 while a 'dead' cell is empty. An 18x18 board Multiple iterations Bigger boards! more (it's relaxing to create new shapes and designs) The Approach My first thought was to use MAKEARRAY because I could use 'r' and 'c' coordinates and there would be no stacking. I devised a recursive function that worked for 1 iteration but failed on subsequent iterations because the use of TAKE/DROP was slowly shrinking the board! The revised approach is essentialy a recursive MAP that uses 3 arrays: the input matrix, the 'r' array (row numbers) and the 'c' array (column numbers). It's my way of using r/c without using MAKEARRAY. For Discussion I welcome any improvements to the existing function and any different approaches someone may have to creating Conway's Game of Life. Conway Lambda follows: Conway =LAMBDA(matrix, iterations, IF( iterations = 0, matrix, Conway( LET( height, ROWS(matrix), width, COLUMNS(matrix), r_arr, SEQUENCE(height) * SEQUENCE(, width, 1, 0), c_arr, SEQUENCE(height, , 1, 0) * SEQUENCE(, width), CheckNeighbors, LAMBDA(lattice, r, c, LET( RCx, LAMBDA(row, col, IFERROR(CHOOSECOLS(CHOOSEROWS(matrix, row), col), 0) ), N, RCx(r - 1, c), NE, RCx(r - 1, c + 1), E, RCx(r, c + 1), SE, RCx(r + 1, c + 1), S, RCx(r + 1, c), SW, RCx(r + 1, c - 1), W, RCx(r, c - 1), NW, RCx(r - 1, c - 1), compass, VSTACK(N, NE, E, SE, S, SW, W, NW), neighbors, SUM(compass), IF( AND(lattice = 0, neighbors = 3), 1, IF( AND(lattice = 1, OR(neighbors = 2, neighbors = 3)), 1, 0 ) ) ) ), MAP(matrix, r_arr, c_arr, CheckNeighbors) ), iterations - 1 ) ) )Patrick2788Apr 23, 2025Silver Contributor2KViews3likes18CommentsAdd Official Password Recovery Option for Protected Office Files
Halo Tim Microsoft, Saya Heru Arwadinata, seorang IT Manager, ingin mengusulkan fitur yang menurut saya akan sangat bermanfaat bagi banyak pengguna Microsoft Office: Mekanisme resmi untuk pemulihan password dokumen Office (khususnya Excel dan Word). Saat ini, ketika pengguna lupa password, tidak ada cara bawaan dari Microsoft untuk memulihkan dokumen tersebut — yang tersedia hanyalah alat pihak ketiga yang: Berbayar Tidak selalu dapat diandalkan Berpotensi membahayakan keamanan data Sebagai perbandingan, ketika kita lupa password email, ada prosedur pemulihan yang jelas, aman, dan mudah (misalnya melalui nomor HP atau email pemulihan). Mengapa tidak menerapkan konsep serupa pada dokumen Office? Mengingat Office digunakan secara luas dalam lingkungan bisnis dan pemerintahan untuk menyimpan data penting, menurut saya Microsoft sebaiknya menyediakan solusi pemulihan yang aman dan terintegrasi, seperti: Verifikasi identitas atau bukti kepemilikan Proses pemulihan melalui akun Microsoft Opsi override oleh admin perusahaan (untuk pengguna enterprise) Hal ini akan sangat membantu mengurangi ketergantungan pada pihak ketiga dan meningkatkan kepercayaan pengguna terhadap Microsoft Office. Terima kasih atas perhatian dan pertimbangannya. Saya sangat menantikan tanggapan dari tim Microsoft maupun komunitas. Hormat saya, Heru Arwadinata ==================================================================== Hello Microsoft Team, I’m Heru Arwadinata, an IT Manager, and I’d like to propose a feature that could be a game-changer for many Office users: An official password recovery option for Microsoft Office documents (particularly Excel and Word). Currently, when a password is lost, users have no native way to recover their documents — relying instead on third-party tools that are often: Expensive Unreliable Potentially insecure As a comparison, when we forget a password for our email account, there’s a clear, safe, and guided recovery process (e.g., via phone or alternate email). Why not bring the same concept to Office documents? Considering Office is widely used for sensitive data in business and government environments, I believe Microsoft should provide a secure, built-in recovery solution, possibly based on: Proof of ownership Identity/account verification Or enterprise admin-level override (for corporate environments) This would significantly reduce reliance on risky third-party tools and boost user confidence. Thank you for your time and for considering this idea. I’d love to hear feedback from the community and Microsoft team. Best regards, Heru Arwadinata20Views0likes1Comment
Resources
Tags
- excel42,595 Topics
- Formulas and Functions24,711 Topics
- Macros and VBA6,408 Topics
- office 3656,025 Topics
- Excel on Mac2,653 Topics
- BI & Data Analysis2,373 Topics
- Excel for web1,917 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,635 Topics