Modifying Existing Calendar User-form

Aug 10, 2009

I got this attached sheet from this very forum. I was wondering is there a way out that the pop out calendar could show two months calendar i.e as now when i click on the calendar button it shows up August's calendar, i want it to show up August's as well as next month's (September) calendar also but in the same window.

View 8 Replies


ADVERTISEMENT

Add A Popup Calendar To A User Form

Oct 20, 2009

Is there a way to add a popup calendar to a user form? I have tried the Calendar 12.0 but I would like a popup calendar for users to click on.

View 4 Replies View Related

User Form With Calendar - Txt Box Not Cell

Aug 1, 2007

I've been scouring the internet trying to find a solution to this one and I keep hitting a wall. I have a userform and I would like people to be able to click on a txtbox and a calendar pop up. they select a date, hit ok and it populates the txt box with that date. I have made the calendar form and I am able to get it to appear but how do I get it to put the date back into the txtbox? There are multiple date txtboxes on the sheet and I need to populate each one individually as you click on them. All of the methods I have found so far are about populating a field in excel

View 9 Replies View Related

Use Of Enter Key On A Calendar User Form

Sep 25, 2006

I've created a calendar user form, much like many of the examples I seen posted here. I've tried all that I could find but none would allow the user to use the Enter Key to make the selection like the mouse click.

I would like the use of the Enter Key to produce the same results as a Mouse Click.

View 3 Replies View Related

Userform Which Allows User To Select A Date Form The Calendar

Mar 4, 2009

I have a userform which allows user to selected a date formt he calendar. In my code I name the value selected myDate. I want to have a line of code at the begginning of my code that checks if myDate = a date already listed in column H on a sheet named "all dor's". if it does match then a msgbox appear saying "date already entered" and the code return to the opened userform.

View 9 Replies View Related

User Form-Easy Selection Of Data To Be Filled In The Form

Jun 3, 2006

find the attached workbook

I have a Database and user form, in the user form i have a field named “Vehicle No” this is a combo box from which a user needs to select the Vehicle numbers, and all these are working fine now, I need your help in the following:

When user selects the second field named "Select Vendor name" i need a pop up window which shows all the Vehicles belongs to the vendor which they have selected, and with the popup window user selects the vehicle number then the Vehicle number combo box should be filled.

Currently users have to select by scrolling through Combo box which takes long time and difficult to find by scrolling.

View 7 Replies View Related

Prevent The User From Saving The Data Input From The User Form If Any Of Those Three Fields Is Left Blank

Feb 9, 2010

I have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.

What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)

View 2 Replies View Related

Look Up Data And Plug Into Form - User Form In Reverse?

Jan 14, 2009

I have created a registration workbook for this year's youth sports league. All of the information is entered into a User Form and separated onto it's appropriate sheet designated by the child's age. Next year, I would like to use this year's workbook to look up returning players.

Will it be possible to add a "lookup" button into my form, or create a lookup program, that once the registrar clicks on the correct player, the information is plugged into the User Form, the registrar adjusts the age and any necessary info, presses enter, and the information is copied into the appropriate category in the new workbook? I haven't worked with User Forms long enough to know if they can be filled in that way, but if this can be done, you are the people who would know.

View 3 Replies View Related

Unload Or Hide User Form On Show Next Form

Dec 2, 2008

I'm using a series of user forms for data entry to a workbook, some of them open next stage user form on completion (OK cmd button).

All that is working fine, but I'd like the initial form to close on showing the next one. I've tried adding Unload and Hide commands following the frmInsertEntry.Show (Next stage form), to no avail, but I'd like this user form to close or hide at the end of the sub.

Private Sub cmdContinueType_Click()

ActiveWorkbook.Sheets("Records").Activate 'Select starting cell in record sheet
Range("N3").Select

Do
If IsEmpty(ActiveCell) = False Then ' Search for next empty cell
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True

If optDrillType = True Then
frmDrillEntry.Show
Else
frmInsertEntry.Show
End If

End Sub

View 9 Replies View Related

Selecting 2 Dates In Calendar Form

Aug 2, 2006

I have created a calendar as part of main userform and I need to be able to select 2 dates and link them to 2 cells in the spreadsheet. According to your help on the calendar form at http://www.ozgrid.com/VBA/excel-calendar-dates.htm I managed to do the basic calendar but need to select in it 2 dates.

View 2 Replies View Related

Edit The Existing Data On Worksheet Using The Form

May 2, 2009

I have created a form in VBA using txt boxes and cmd's. I want the abitility to edit the existing data on my excel worksheet using the form. Currently, I can add data, but not search through the existing data on the form.

I have been using the excel tips and it has been great, but I am stumped at this point. This is my first time to every post a message.

View 4 Replies View Related

Save File Name From Textbox & Calendar In Form

Aug 11, 2008

After a bunch of false starts I am not getting very far and after searching the message board have failed to come up with the right clue.

I am trying to create some vba code that would use input from a form to create a file name that would save the file in the current folder.

e.g. Foghorn Leghorn expenses Aug 10 2008.xls

I am using calendar control named “calendarFinal” and a text box named “txtName” . The text box to show the user the suggested file name is txtFileName.

Among other things, the date from the calendar control gives a date like 08/08/2008 and I suspect that the slashes are going to give me grief.

A confirmation message box would be nice. (vbOk?)

View 9 Replies View Related

Calendar Form/Control To Calculate NetWorkDays

Sep 29, 2006

I would like to be able to calculate the number of Net Working Days between 2 dates using the dates returned from the calendar form and have the number of working days placed into a separate cell. Example, I use the popup calendar in A1 and select 10/1/06, I then use the popup calendar in B1 and select 10/9/06 and the number of Net Wroking Days is placed in cell C1. Is there a way to calculate the number of working days between the two chosen dates?

I have the forms for the calendar already created and am using this for the popup calendar but don't know where to start to calculate the working days from the calendars results.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'This will launch when A1 and/or B1 is selected
If Target.Address = "$A$1" Or Target.Address = "$B$1" Then
CalendarFrm.Show
End If
End Sub

View 3 Replies View Related

ListBox Existing Value Or User Choice

Apr 12, 2006

I have a form users can use to input information into a spreadsheet, but also use to recall data (so they can search for a record, recall it, amend one or two fields and then re-save it)

I would like a listbox to display what is already in the cell in the worksheet to start with. Only when they then click in the listbox would they then get a list of predefined options.

So they recall the data onto the from and the listbox says "squatters", because it is an old value that shouldn't be used anymore. Once they click to choose another option, however, they only get a choice of either "vacant", "occupied" or "WIP" (for example).

View 3 Replies View Related

How To Get Data Entered In Form To Auto Populate Into Calendar

Jun 26, 2014

I am trying to build a Calendar that pulls all of it's entries from data submitted via user form. To be more clear, I built a basic user form in VBA where I can submit this data: name, brief description, Time/duration, and date. Instead of the data I enter into the form populating in specific cells in my Excel workbook, I would like for the information to be populated into a calendar based on the date.

View 1 Replies View Related

How To Prevent User From Clicking On Days In Calendar Control 8.0

Jun 22, 2013

Is there a way to prevent a user from clicking on the days in the Calendar Control 8.0? I am trying to place 12 calendar controls on a worksheet for reference only. I am using a linked cell to reflect what date the Calendar is to display.

View 2 Replies View Related

ActivatE Calendar When A User Selects A Specific Cell

Jan 29, 2009

I'm wondering if someone can help me with this. I am using the excel calendar control and trying to activate it when a user selects a specific cell "C3". I can get it to activate when I move off the cell, but it's not working when they click on the cell.

Sheet1
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C3")) Then
Call OpenCalendar
MsgBox "Calendar"
End If
End Sub

Userform2 (I have this code under here)...............................

View 9 Replies View Related

Calendar To Allow The User To Select A Date And Automatically Put That In A Specific Cell

Jun 11, 2003

I have created a user form using the addins that come with excel to create a calendar that will allow the user to select a date and automatically put that in a specific cell. My system is office 2000.

The code is as follows:

Private Sub OK_Click()

Dim i As Integer
Dim myCell As Range

i = 0

For Each myCell In Selection
myCell.Value = Calendar1.Value + i
i = i + 1
Next myCell

Unload Me
End Sub

Now, I gave it to my boss who has xp, and I get the following VB error when she chooses a date and clicks on the ok button:

Method 'Value' of object 'ICalendar' Failed

View 9 Replies View Related

Popup Calendar When User Double Clicks In A Range Of Cells

May 1, 2007

writing the correct command to auto popup a calendar when a user doubleclicks in any cell in a range of cells. I have the code for individual cells but would like to apply to a very large range of cells and do not know what the correct command is.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Select Case Target.Address
Case "$C$160", "$C$161", "$C$162", "$C$163"
Cancel = True
Call OpenCalendar
End Select
End Sub

View 6 Replies View Related

User Forms- Create A User Form That Will "pop Up"

Oct 25, 2007

I have a spreadsheet with the following headings:

A
Claims Number

B
Name

C
Scheme

D
Admin

E
Date

I need to create a user form that will "pop up" and ask the administrator to enter the above details.

A - should be created automatically (ie last claim number + 1)
B - user enters manually
C - data retrieved from a list
D - data retrieved from a list
E - date is the date the information is entered

View 9 Replies View Related

User Form

Feb 24, 2009

I have a user form that I want to take the information and have it input on the worksheet. I want it to start at A3 and check to see if that cell is "" and if it is not then enter the data from the from horizontally. If A3 is not "" then continue down column A untill the first nonblank cell is and then select that cell and have the data entered horizontally.

I have this code so far but it is not working.

Private Sub cmdSubmit_Click()
Dim Month As Variant

Month = Me.cmbMonth.Value

ActiveWorkbook.Sheets(Month).Activate

I have done a bit of excel programming last year but have not done any for the last 4 months so I am a bit rusty.

View 9 Replies View Related

Combobox In A User Form

Aug 30, 2007

I've written a workbook that enables my workmates to enter sample information easily (workbook attached). What i need help on i cant get the combobox 's on the user form to pick up the related info in worksheet named "data" and insert it into the relavant coloumn in tab named "Results". I can get it to work without using combobox's and just typing the info into a textbox but i wanted to use combobox's.

Another thing i wanted to do was pick invidual results and send them the "Report" for printing. how would i do that.

View 14 Replies View Related

User Form Drop Down Box

May 25, 2008

I have a project, i want to create a user form, basically i have a work book that contains dinner menu's on column A and ingredients in column b.
I would like to create a user form that have a drop down box that would show all the possible menu's referencing my workbook sheet1 column A values. and by selecting a item, i would like to be able to show all ingredients needed, is there a way to do this?.
I hope so, it would be so cool to do this.

View 11 Replies View Related

User Form Interaction

Jun 22, 2009

I have created a multi utility user form that user can initialize by a shortcut key. The problem if user want to see the content on sheet or want to change the active cell, he has to close the form and then do any action. This form is initialized by a command and default included in excel as a Add-in. Is there is any way to make the form floating i.e. user can manipulate the data and can see the form as well.

View 4 Replies View Related

Using The Scroll Bar In A User Form

Jul 8, 2009

On a userform, I have 5 paragraphs of text that the user needs to read. The problem is the user can't see all 5 paragraphs, the user is only able to see about two paragraphs. I don't want to make the userform larger but I would like to add some type of scroll bar that would allow the user to scroll up and down to view all of the text.

View 7 Replies View Related

Comments In User Form ...

Dec 20, 2009

Can anybody help me with a code that shows a comment within the user form when specific a checkbox is selected?

I am attaching a sample file with user form containing 6 checkboxes. I need when Name6 is selected, a comment "Test" to appear inside the user form beside the checkbox.

View 6 Replies View Related

Placing User Form

Apr 6, 2007

I have created a user form (thanks Datsmart), and now need to place the data that will be inserted in that userfom onto my spreadsheet.

The spreadsheet will have 50 rows, each containing a different project. There will be a button on each row to activate the user form for that specific row. They click the button on the spreadsheet, and the user form opens. They enter the data on the user form, and once they click the "add comment" button on the user form, the data should be entered in the last cell of the row on which the button is located.

Now the complicated part:

The users will use that for to update the project from week to week, but each week's comment needs to go in the same cell, but above the previous comment.

IE:

Week 1

Jan 1: Project lauched

Week 2

Jan 6: Project budget submitted
Jan 1: Project lauched

Week 3

Jan 22: Budget approved
Jan 6: Project budget submitted
Jan 1: Project lauched

The date being the date from the user form, and the comment being the comment from the user form. If the latest date can be bolded that would be a bonus.

They each have to go in the same cell cause all relate to the same project. This same thing will be repeated 50 times for each different project.

View 9 Replies View Related

User Form Printing

May 24, 2007

I came here yesterday asking for help and was helped immediatly, but I have another question/problem. I got my user form up and running, however I've just been informed that the form has to be able to be printed out. So basically I need this user form with all the data on it and I need it to be printed.

Is there a way to add a command button perhaps that prints out the form with the data on it? (Ex: Imput Data, hit Print command button, have an electronic and hard copy of the information)

View 9 Replies View Related

Mask In User Form

Oct 16, 2007

I have a user form with 2 textboxes (used as parameters for an ODBC query). The entry should be a period, as yyyymm. How can I check, for instance when clicking the Ok button after entry, that both textboxes are of the "000000" format and the last 2 numbers are between 01 and 12?

View 9 Replies View Related

Counter For User Form

May 10, 2009

I have the following code in a user form....

Private Sub cbSearch_Click()
Dim Product As Range
Set Product = Sheets("Master").Range("A1:A300").Find(Val(tbLookFor), lookat:=xlWhole, LookIn:=xlValues)
If Product Is Nothing Then
MsgBox "Incorrect Product code, try again"
Else
'Populate the userform with data
Dim counter
counter = (0) + 1
Label35 = counter
tbData1 = Product.Offset(0, 1) 'Down 1 row, over 1 column
tbData2 = Product.Offset(0, 2)
tbData3 = Product.Offset(0, 3)
tbData4 = Product.Offset(0, 4)
etc, etc, etc
I need the counter to increase every time a search is performed, at the moment it only does one count, no matter how many searches are performed.

What do I need to add to the counter part of the code for it to increase by 1 every time?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved