I have created a form that converts latitude / longitude from Decimal Degrees to Degrees Minutes Seconds decimal seconds. I want my coworkers to be able to use the form, but I don't want them to see the excel window/worksheet when they open it up.... I thought I had received an email once that appeared to be an excel file but when you opened it, it was just a form. I have tried all I can think of to no avail.
View 3 RepliesI have a data in excel sheet in Table format, in the first column i have added a unique Prod_ID. In form there is a search text box by entering the Prod ID & click of search button i need to display the respective row along with the Headers.
View 1 Replies View RelatedI have a form that is built based on the number a person enters. For Example - if the person enters the number 2 then 2 ComboBoxes are entered on the form.
The problem that I am having is that the list is not showing when the form is loaded. In the Project Screen all is OK until the final step when the form is Shown.
I have used the Forms toolbar to create a command button on a chart.
However, the text for the command button is hidden. If I do an "Edit Text" on the button, it shows up, but otherwise the button appears blank, even when selected.
i want to do the following: initialize a sheet by showing form1, which accepts user input for rows and cols name a range on the sheet of size rows x cols display form2 which is just a "DONE" button that they click when they're finished pause/stop the macros and allow the user to fill in values for that range start up some other macros when they press the "DONE" button.
i tried it and found that when you display a form it locks the sheet (can't select the sheet to input values) and you can't even alt tab away from the form. is there a way around this?
MyUserForm.Show
The above code works in a worksheet code section but not in a custom Module? Why? How can I make this call outside of the Worksheet section.
I recorded a macro to open the Form on the Data Menu. Sample Worksheet Attached. After starting the macro recorder I selected the Food table cell (located to the right on the worksheet). Then went to the Menu bar.... Data Forms... and Clicked new.... followed by close and then stopped the macro Recorder. It produced the following code.... which reflects a code error when run.
Sub McrEnterFood()
'
' McrEnterFood Macro
' Macro recorded 20/01/2010
Range("P1:U16").Select
ActiveSheet.ShowDataForm
End Sub
I have the following code that displays a form at a user defined time and if the user does not press "Stop" then the workbook saves and closes. The user can press stop then the workbook remains open.
Here is what I have where:
Admin_Auto_Shutdown = Yes or No
Admin_Auto_Shutdown_Time = 3:34pm or user defined time (This doesn't seem to work??)
'Auto Shutdown CloseandSave
If UCase(wb.Worksheets("Admin"). Range("Admin_Auto_Shutdown").Value) = "YES" Then
Application .OnTime TimeValue("Admin_Auto_Shutdown_Time"), "AutoShutdown"
End If
Sub AutoShutdown()
Application.OnTime TimeValue("Admin_Auto_Shutdown_Time"), "AutoShutdown"
Auto_Shutdown_Form.Show
End Sub
Now, my question is about a timer that I can show on a form. When the form is displayed I would like to give the user 30 seconds to press stop (and keep the workbook open) or to press proceed and save and close or to not do anything and the workbook would close and save when the timer reaches zero.
Code for user form which is missing most everything...
Private Sub Halt_Click()
'If user whats to continue without closing
Auto_Shutdown_Form.Hide
End Sub
Private Sub Proceed_Click()
'If user whats to save and close
Auto_Shutdown_Form.Hide
How do I add a timer to this code where it will run this at the end of the timer?
Auto_Shutdown_Form.Hide
Application.DisplayAlerts = False
With ThisWorkbook
.Saved = True
.Close
End With
I have a cell that contains the =Day1!G4. It reveals what is on another worksheet, but I want to be able to have the next cell be: =Day2!G4. Is there any way that I can code this without having to physically type in every cell? I tried, =Day1+1!G4 but it didn't like that.
View 12 Replies View RelatedI have three charts on different worksheets - what I want to do is to use a macro to display each chart for 30 seconds and switch to another worksheet and display the chart on that worksheet.
something like below:
ActiveSheet="Sheet1"
ActiveSheet="Sheet2"
ActiveSheet="Sheet3"
Application.OnTime Now + TimeSerial(0, 0, 30), "Procedure_name"
I've received a workbook that contains maybe 60+ worksheets. To navigate the workbook, a person must use the hyperlinks on each sheet. However the worksheet tabs do not appear at the bottom of the sheet. I've checked Tools / Options / View / Sheet Tabs and the checkbox is checked. II've also tried unchecking and rechecking the box.) There are no custom views created.
View 2 Replies View RelatedFor some reason I need to display quite a few computer's installed software from system information in to separate worksheet.How can I copy all installed programs and paste into new worksheet with a code?
View 1 Replies View RelatedAn integer in stored in Sheet1!A1. I want a formula in Sheet1!A2 to display data of sheetx!A3 where x is the number chosen in Sheet1!A1.
e.g. Sheet1!A1 store 3. Then Sheet1!A2 will display Sheet3!A3.
e.g. Sheet1!A1 store 7. Then Sheet1!A2 will display Sheet7!A3.
Is there a formula/function in excel that can take all the cells in a column, lets say Column A, and paste/display it in another file without the spaces between the cells with values and without duplicates?
Worksheet1
Column A
1 Name
2
3 Mike
4 Rob
5 Ryan
6
7 Mindy
8 Paul
9
10 Rob
11
12 Mindy
13 Chris
Worksheet2
Column A
1 Name
2 Mike
3 Rob
4 Ryan
5 Mindy
6 Paul
7 Chris
8
9
10
11
12
13
how do I automatically add beside the name the colum title where it previously existed. see the attached.
View 2 Replies View RelatedI have an Excel 2007 workbook that's been used for 5 months or so now. Recently, people I email it to say they can only see one worksheet in the workbook when they open it, and are unable to switch to any other worksheets in the workbook (they can't even see the tabs). They are in the "normal" view, and I have no idea what else could be wrong. Did I mess something up with the protection? Any other ideas to check?
View 4 Replies View RelatedWorking with an existing macro from this forum. How do I create the array showing the number of sheets found? I know from a MsgBox that two sheets are found.
View 3 Replies View RelatedI wanted to create a multiple drop down lists (using data validation) in column B (50 in all, every 3rd line) whereby, multiple, comma deliminated, results would display in each of the cells - for use elsewhere in the spreadsheet.
I found some code (as follows) which worked perfectly for me
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
Dim oldVal As String
[Code].....
As I mentioned above, I don't really understand the code and all I know is that the line about halfway down "If Target.Column = 2 Then" is defining which column (B) this will work in.
The problem I am having is that I need to protect the worksheet and the moment I "protect" the worksheet, the functionality of displaying multiple values goes away and the drop-down list reverts to only displaying one of the available values.
I have code in a worksheet that creates a new worksheet when clicking a button:
View 3 Replies View RelatedI'm adding a form to a worksheet for the first. I tried to follow an example from the internet and then adapt for own form but have got lost and don't know where.
Attached is the excel file i am working on. On the summary worksheet i have added a button which works fine and opens up the form i have made.
My problem is it doesn't enter the data into the relevant cells on the relevant worksheets. I think the form should be quite self explanatory.
I have a user form that allows me to add items to the last row in my worksheet via the form. However if I want to manually add something or modify something on the sheet while the user form is open it would not allow this. Is there some properties of the user form I can modification to accommodate this?
View 5 Replies View RelatedI am using Excel 2007 and have created a form associated with a worksheet. I would like to click on the *.xlsm, or any other file and have just the the form appear. Three other sales people will be using the form and I would like to make it as simple as possible.
View 9 Replies View RelatedI have a data list which needs to be updated by others on a shared drive. I want to protect the worksheet as there is other info on it (advancefilter from the main list). The problem is that the >>Data>>Form tool will open, but all the boxes necessary to update the list are greyed out (New, Delete etc.)
My other option is to create a macro to advance filter out the other data to another worksheet.
I've taken some time to learn about building an excel data entry form. I'm looking to add a find button.
1) users would type in something in the ID text box, then click on "find". The code will then try to find that record in the worksheet(just sheet1).
when it is found, i want the forms to auto-populate values from that row.
right now, the search works except when you are trying to search a value that that is NOT in the worksheet. I'm getting an error message that i've never seen before.
[Code] .....
form based input.xlsm
Is there something I can program into my form so that when a record is added and the 'add' button is clicked, it not only adds the record to the work sheet but saves the workbook as well.
View 2 Replies View RelatedI've only just starting using Excel for anything other than basic calculations and have got a little stuck with a user form. On my attached spreadsheet I am trying to set up a form for staff incident reporting. There is a Contents worksheet and then each incident has it's own detailed worksheet. The user will click on 'create new incident' on the Contents page.
This opens a user form. From this form I want to populate the contents worksheet. I then also want it to populate the relevant incident worksheet. I can populate the contents page but I need help getting the correct Incident worksheet populated at the same time. Hopefully all will become clear running the file.
I want to have a Checkbox (Form) that is in my Worksheet to disable/gray-out once it is selected. I don't want people to be able to uncheck it again. I want them to be forced to click another Checkbox to enable it again.
Example:
Two Checkboxes:
Check Box 1 = "Apply"
Check Box 2 = "Delete"
Once "Apply" is checked, gray it out. This will force a user to click "Delete" in order for the "Apply" button to be enabled again. I do not want a user to click "Apply" once selected as their way of 'deleting' the information.
I have to questions...
1. I have a form that I setup to open when my excel db is opened. How do I get the excel db to minimize or hide so that only the form is open.
2. How to I add minimize and maximize buttons to the forms I have created?
how to get a list of the properties for form control shapes (not control toolbox shapes) that are placed on a worksheet (not on a userform). Eg., a button, checkbox, combobox, etc.
If it's possible, I'm interested in working with properties like "enabled", "caption", etc. that aren't listed on the "Format Control Properties" dialog.
I understand you can edit properties of a form control shape via VBA code (See example below), however, I can't seem to find anything within the object browser about them.
EXAMPLE
With ActiveSheet.Shapes("Scroll Bar 2").ControlFormat
.Min = 10
.Max = 150
End With
Using VBA, does anyone know how I can change what is selected in a listbox that is a form control on a worksheet, not on a userform?
View 5 Replies View Related