No announcements
Found 2914677 threads
-
0 VotesReference to cells and userform elements
I have a Excel project with some user forms and sheets. I want get values from different sheets cells and user form elements. It has many sets of ...Unanswered | 2 Replies | 446 Views | Created by csaba114 - Saturday, January 21, 2017 4:15 PM | Last reply by csaba114 - Sunday, January 22, 2017 7:29 AM
-
0 Votes
Update Cells Value from Userform Label Text
I have created a userform in one of my excel and want to save the information of the label into the excel cells. In my userform i have multiple ...Unanswered | 1 Replies | 695 Views | Created by MOINSK21 - Saturday, January 25, 2014 8:57 PM | Last reply by MOINSK21 - Saturday, January 25, 2014 9:25 PM -
0 Votes
Userform
The easiest way to load/save data into/from a sheet/userform is to use the TAG property of the controls. Write the cell reference into the TAG, e.g. "A2", ...Answered | 1 Replies | 647 Views | Created by Thurton - Monday, March 31, 2014 3:41 AM | Last reply by Andreas Killer - Monday, March 31, 2014 10:27 AM -
1 Votes
Reference Elements by String
So how would I reference the control like this to set visibility? Currently I use "If ReferenceEquals(sender,Image1)" and one for each image then to ...Answered | 3 Replies | 658 Views | Created by Maya Key - Sunday, January 4, 2015 2:42 PM | Last reply by Maya Key - Monday, January 5, 2015 5:23 PM -
0 Votes
Access elements in Datagrid cells
I have column with a combobox in my Datagrid, and I need to access all of the comboboxes in every single rows of the datagrid using a for loop. Is there a way to ...Answered | 1 Replies | 1511 Views | Created by Jungtionizer - Monday, November 1, 2010 2:18 PM | Last reply by cjinojl - Monday, November 1, 2010 4:08 PM -
0 Votes
Userform and fdlFileDialogue
There is no built-in way to do that. You'd have to build your own file dialog from controls on the userform. In my opinion, that would be more work than it's worth - I'd ...Answered | 4 Replies | 448 Views | Created by Budget Programmer - Thursday, April 9, 2015 2:50 AM | Last reply by Budget Programmer - Thursday, April 9, 2015 11:18 AM -
0 Votes
Assigning a userform to cells in a column
I'm very new to coding in excel and would like to create an ordering list. The first command I would like toUnanswered | 1 Replies | 477 Views | Created by anewskillforhelp - Sunday, August 11, 2019 11:16 PM | Last reply by Ashidacchi - Monday, August 12, 2019 5:04 AM -
0 Votes
Send Userform TextBox value to range of cells on worksheet
Wow! Works great!!! I had to change... If rw = 4 to If rw = 5 so ...Answered | 2 Replies | 4817 Views | Created by suznal - Tuesday, April 14, 2009 6:22 PM | Last reply by suznal - Tuesday, April 14, 2009 8:01 PM -
0 Votes
Populate Pdf fields from excel userform or excel cells
Is there any macro to fill PDF form fields from excel userform or excel cells? I found some example but these requires using Adobe Acrobat, and ...Answered | 1 Replies | 714 Views | Created by Ahmed Morsyy - Friday, November 28, 2014 8:27 PM | Last reply by Fei Xue - Monday, December 1, 2014 5:43 AM -
0 Votes
Access elements bye reference
Did you get any exception? Your code looks fine. Refer to this: http://msdn.microsoft.com/en-us/library/ms180906(v=vs.80).aspxAnswered | 1 Replies | 447 Views | Created by GogaS13 - Wednesday, December 4, 2013 6:37 PM | Last reply by v-hypo - Thursday, December 5, 2013 7:19 AM -
0 Votes
UserForm
>>" I have an userform in VBA Excel that contain checkbox and I want to rotate it 90 degrees " How Can I ?<<Answered | 4 Replies | 468 Views | Created by MansourSadeghi - Wednesday, August 24, 2016 5:34 PM | Last reply by David_JunFeng - Friday, August 26, 2016 2:38 AM -
0 Votes
Loop through cells given the reference
Hello, i am writing a custom function in vba, and need to loop through the reference passed, and get all the ...Answered | 1 Replies | 3822 Views | Created by Oghenez - Wednesday, June 22, 2011 5:14 PM | Last reply by Oghenez - Wednesday, June 22, 2011 6:18 PM -
0 Votes
Excel VBA and UserForm
includes a userform and the other some code that you want to communicate with the userform. Assuming you are talking about the latter, ...Answered | 9 Replies | 10375 Views | Created by Ajay Check - Wednesday, May 23, 2012 1:16 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Friday, June 1, 2012 9:37 PM -
0 Votes
How to reference a UserForm within Excel VBA Macro
' set the userform caption AddSheetUserForm.Caption = "Add Sheet User Form" ' change the text in a a text box on user form AddSheetUserFormUnanswered | 1 Replies | 8180 Views | Created by gin4sing - Wednesday, May 9, 2012 12:28 AM | Last reply by Ed Ferrero - Friday, May 18, 2012 7:24 AM -
0 Votes
How to dynamically reference cells in a new row, added at the end of Excel worksheet?
Hi, I have a excel sheet that copies data entered by user in a UserForm and puts it in the sheet by insertng a row at the end, using VBA. There are cells in the ...Unanswered | 1 Replies | 3386 Views | Created by Saramay - Wednesday, July 15, 2009 7:22 PM | Last reply by Derek Smyth - Wednesday, July 15, 2009 9:46 PM -
0 Votes
Excel UserForm and ranges
: I have a userform to collect information and then want to move the information back to the worksheet ...Unanswered | 2 Replies | 4101 Views | Created by Joyce4 - Tuesday, March 8, 2011 4:18 PM | Last reply by Dave Peterson - Tuesday, March 8, 2011 8:41 PM -
0 Votes
UserForm sending a range of cells through Lotus Notes
It is not clear how you want to arrange the data from the cells in column A, E and G of the row in which the selection is located however, the following will concatentate ...Unanswered | 1 Replies | 2907 Views | Created by Alpha212 - Saturday, February 23, 2013 7:48 PM | Last reply by Doug Robbins MVP - Sunday, February 24, 2013 9:37 AM -
0 Votes
Dynamic Userform
dynamically create a userform. This userform will have multiple pages. Each page will be named from folders within a main folder. The userform page will consist of images ... -
0 Votes
Userform
You say "tab stop and tab key behaviour properly " but what values have you set them to? Tab order is for setting the order that the controls on the ...Unanswered | 2 Replies | 433 Views | Created by Moses324 - Thursday, May 28, 2015 9:24 PM | Last reply by Starian chen - Friday, May 29, 2015 6:36 AM -
0 Votes
Dynamic UserForm and ADO to Access DB
Access. The macros in Excel contain modules that create dynamic userforms, including having the macro write the module code (VBComponents) for the userform and ...Answered | 1 Replies | 1284 Views | Created by Stathy Kouf - Monday, September 23, 2013 11:01 PM | Last reply by Kyle234 - Wednesday, September 25, 2013 12:17 PM - Items 1 to 20 of 2914677 Next ›
No announcements
