So you can edit string or add something to it only when it's really necessary. With dictionary it's easy to answer a question "Is that string are really unique?": Public Function IsUnique(ByVal str As String) As Boolean I advise you not to hope for it - when you need something unique - always use dictionary. Static counter is ok if you are not a perfectionist, you are good with Long type limitations and all of your buttons are deleted upon quiting excel. Set NewButton = (a, b, c, d)īut I suggest that you work on the uniqueness of your names. Try to give something unique! Sub CreateButton(a, b, c, d As Double, s As String) If you have shared a macro-enabled workbook with another user and the macros subsequently stopped working, it’s possible that they accidentally re-saved it as an ordinary workbook that can’t contain macros. Note: Application.Caller is a string with name of a button in your case. Only a macro-enabled workbook can contain macros. Since you don't mentioned where( and how) your function-like sub CreateButton are called from there's only one way to reproduct your problem for me - calling sub multiple time with same s parameter.
Your problem (I assume) is because of you give same name over and over, so with Set o = ActiveSheet.Buttons(Application.Caller) line you pick your first button with given name! Second - why you need thoose integers? Use Longs!
Is not the same as Dim r As Integer, i As Integer, c As IntegerĬreateButton(a As Double, b As Double, c As Double, d As Double, s As String) I highly recommend using readable variable names instead of a, b, c and o!Īnd be aware that Dim r, i, c As Integer 'r and i are of type variant here only c is integerĬreateButton(a, b, c, d As Double, s As String) 'this part above assures that the name for the button is unique. Sub CreateButton(left As Double, top As Double, width As Double, height As Double, name As String, caption As String) I also added a check so that only unique button names are accepted on creation. Name must be unique, caption can be the same on all buttons. Name is what Application.Caller uses and caption is what is written on the button. I changed your CreateButton() sub so it can take a name and a caption as parameter. the one thing I don't seem to understand is how do I switch between using a macro or using the delete button for instance.
#Apex 350 macro buttons not working pro#
Select: Press and hold button, then drag pen tip on screen to select contents. Macro keys or ins-del keys steelseries apex pro Help So I recently got a steelseries apex pro, while I do love the feel of everything on it. Right-Click: Press and hold button, touch screen with pen tip, then release button to show a context menu. The issue is that you don't have unique names for your buttons. Erase: Press and hold button, then drag on screen to erase contents.
0 kommentar(er)
