I have a form that has a multipage control on it. I would like to have it return to the page where the user left off when the form is loaded. I thought it would be simple enough to have a value in a cell of the spreadsheet store the page number each time the user clicked on a page then when the form reloads it uses that number to select that page. I have not been able to figure out how to get the page number to the cell I want when the user clicks the page.
The loading of the form and selecting the page from a stored value in a cell is no problem.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.