• 2019-03-30 The time has come the walrus said. We're waiting on the developers to put their heads together, but in the next few days you should expect that WindowsSecrets.com will be melded into AskWoody.com. Imperfectly, yes, but the seams shouldn't be insurmountable. If you haven't yet set up an account on AskWoody.com, now would be a very good time to do so. If your AskWoody account has the same email address as your Windows Secrets account, the merge should go through quite easily: All of your WSL posts will be folded into your AskWoody account. The matching email address is key. Here's how things will proceed. WindowsSecrets.com will be shut down, with a redirect to AskWoody.com. (That means if you point your browser to WindowsSecrets.com, you'll end up at AskWoody.com.) Shortly afterward, the frozen Windows Secrets database will be merged into the AskWoody database. At that point, expect slowdowns. Navigate to your Developer Tab in the Ribbon. Click the Insert drop down button in the Controls group. Select the Option Button Form Control (first row, last icon) Your mouse should now look like cross hairs and you will just want to click somewhere on your spreadsheet to draw the Option Button. Create a Button in Excel Using VBA. Learn How To Create Tabs in Microsoft Excel In This Easy VBA Tutorial Video - Duration: 24:14. Excel For Freelancers 421,245 views. We're moving a metric ton of data, so don't be surprised if things are sluggish for a day or even more. While the merge is under way, you'll have sporadic access to your account and your posts. We may even shut down AskWoody.com for a bit to accommodate the traffic. When things come back up, there will be instructions and help for making the leap. With a bit of luck it won't be too jarring. Get an account set up on AskWoody with an email address that's the same as the one you have here. Don't be too surprised when things turn sluggish. And realize that, at some point, you won't be in Kansas any more. There's an overview of what to expect https://www.askwoody.com/welcome/. Hi All, I'm having a problem creating buttons in VBA. The code I have posted below creates two buttons in cells J9 and K9 on the 'PART NUMBER' sheet successfully however, the text in both buttons is 'DELETE' I'm trying to show 'EDIT' in cell J9 and 'DELETE' in K9 and am not sure where I'm going wrong. Also, is there a way I can change the button background color to blue for the 'EDIT' button and red for the 'DELETE' button. I only want these buttons created under certain conditions and so far the code is working well for me except for the problems previously mentioned. Thanks so much for your help!
![]() Then use code like this. Star wars jedi battles. Sheets('PART NUMBER').Select ActiveSheet.Shapes('btnEdit').Visible = True.to show the button (I named this one 'btnEdit') and like this to hide a button. Sheets('PART NUMBER').Select ActiveSheet.Shapes('btnDelete').Visible = False see attached workbook for example zeddy. Thanks all for your help! Steve, Thanks for your code, it works perfectly I added code to the beginning of the sub to delete any buttons that were previously created. I can change the button font or font color but I can't seem to find any code to change the button color, is this not possible? Install photo transfer app. It's not a deal breaker, but it would be nice if the 'EDIT' button were blue and the 'DELETE' button were red. I'd have to do this through a macro because each time the create_buttons sub is run there could be a different number of rows in the worksheet that would have the 'EDIT' and 'DELETE' buttons. Thanks again!
0 Comments
Leave a Reply. |