squidge1990
Last Activity: Mar 12 '07, 02:28 PM
Joined: Nov 15 '06
Location:
-
Hyperlink Buttton in excel
Im tryin to hyperlink a vba button on a form in excel, it needs to link to an external site which acts as a help to the program i am writing. i would appreciate it if some could help with this problem. thnks -
that doesn't work it still seems to do the same as it did before thank anyways... -
Excel VBA form
Im trying to get a form to display a certain sheet when a button is clicked on a form. but i have found a problem when the button is clicked it will go to the correct sheet but it will not hide the form that the button is on. here is the code that i have produced for this. if any could help i would be very thankful.
...Code:Private Sub CommandButton19_Click() Worksheets("Accounts").Visible = True HighLevel.Hide -
vba forms in excel
im trying to write secure user areas using forms but i dont know how to connect a button the forms.
i've created a form that runs when the workbook is opened but it wont log the user in properly because it wont read the variables properly or move to the forms.
could someone help me please -
Back Button in excel
when a user logs in it will store there security level in a public variable called level. im trying to use this so that i can create a back button to instead of going back the login screen it will go back to the users switchboard. but the code doesnt seem to be reading from the variable.
heres the code of the back
Private Sub back_Click()
If level = low Then
Worksheets("Low lev").Visible = True
... -
thanks for your help it's worked just need a little tweaking to suit my program thanks againLeave a comment:
-
search and display a value in excel
im searching a page of products to find a certain product. the search must take the value that i have input into a certain cell then search through the like of products until in makes a match and then take details of that product and display it on a seperate page then move to the page that is displaying the details of the product. i have an idea of how to do this but as im kind of new to vba i dont know what sort of code to be using or how to search... -
whne the incorrect details have been entered it will close the workbook and i choose whether i want to save the changes that have made to the workbook before it closes.
i have to set to false so it doesnt save the changes that have been made when the wrong password and username are entered.Leave a comment:
-
trouble creating login in excel
i have created a database using excel and i have to set a security level i have written all of the vba code correctly i think but it just does seem to work properly. here is the code below if anyone could point out any problems with it would be much appreciated.
...Code:Private Sub Login_Click() Dim name, password, found, loops found = 0 loops = 0 name = Range("Username").Value
No activity results to display
Leave a comment: