Search results for query: *

Thanks Skip.

Can anyone tell me if it is possible to have two different types of formats on one cell? For example if I enter 100%, do a percent formula and if I enter 100 I do an integer value formula.

This unprotects the full worksheet, I need only one row on the different sheet to be updateable. Meaning, Sheet1 has the checkbox, when the checkbox is checked and the user goes to sheet2 only one row should be updateable, they should not be able to update any other row which was protected...

Yes the getMortgage function is an Add-In and Userform are in the same workbook. When the user opens up the workbook, the data which is stored in our database needs to be displayed. To get the data we use the getMortgage function but the user must login and thats how the Userform comes into the...

Yes the posted code is in the Userform module. Here is the code when the userform is called Public Function getMortgage(uwWorkbook As Excel.Workbook, bSilent As Boolean, pwdExcelProtection As String, Optional ByRef bHadErrors As Boolean) As Boolean Dim myObj As Object Dim blnResult As...

Here you go: Option Explicit Private strErrorMessage As String Private Const ERR_LOGIN_ACCESS_DENIED = "Access Denied! Please enter a valid username and password." Private Const ERR_LOGIN_EMPTY_USERNAME = "Username cannot be empty!" & vbCrLf & "Please enter a valid username and password."...

Mike thanks you for the help but I have a question, when I put the code into my spreadsheet, my login form will not display. It basically bypasses the full login process and goes directly to the database without even asking for the users information. Am I doing something incorrectly? Thanks so...

Heres the issue, I have a excel spreadsheet that has 5 sheets. On one of the sheets there is a checkbox, when the checkbox is checked, two different sheets need to do the same thing. Both sheets have locked cells, with different formatting. I need to unlock each cell and allow all users to...

If the users enters a value we do nothing actually, the design at this point is to allow the user full access to all fields and formulas can be distroyed if needed. But we do want to know if the formula was replaced by a user entering data.

Hi everyone, First off I just wanted to say that this is GREAT, I have gotten so much good advice that I cant thank everyone enough. Ok here is the problem, I have a cell on my spreadsheet, which if empty when the sheet is opened. I want the cell to change its color when a user goes in and...

Gerry thats correct. If a user downloads the file again it t will be a new file and so the cancel button should be disabled and the user must login to the excel spreadsheet again.

I want the cancel button to be disabled only the first time ever a users opens a file that he/she downloads from our website.

Hi, I have a excel spreadsheet that when opened asks a user to login. I want the Cancel button not to be enabled when the user opens the file for the first time but after that the cancel button should be disabled. Is that possible?

Hi everyone, Can someone help with this small issue, I need to change the cell color if a value is changed after the first value has been saved to the database. Thanks

Hi everyone, Could anyone tell me how to create a Save As dialog box to pop up when a user clicks on a custom made menu option in excel. I have menu option called Check In, when a user clicks it a popup should display like a save as option. The user then can choose to save the excel file in...

Hi Everyone, Here is my problem, I has windows xp installed and work on my excel worksheet using excel 2000. I upload the spreadsheet to our website to allow users to download this as a templete to complete their work which is then saved to the database. Now the problem is if a user has...

Hi Everyone, Here is my issue. I have a excel work book that has 5 sheets. On one of the sheets there is a checkbox, when the checkbox is checked I need to unprotect cells to allow the users to update it in a different sheet in the workbook. As VBA is new to me, can anyone give me some...

I have currently working on a excel sheet that has 10 fields and 2 of them are list values. For example there is a list of different types of houses, condo,single-family, multifamily etc. If the user has selected "condo" from the list then the list box should not be updatable. But if the users...

Hi Everyone, I have a excel spreadsheet that has a list box. If a user has already selected a value from the list the cell then should NOT be updateable but if the user has not selected any value then he/she should be able to update the cell. I just have no idea how to get it done. Any...