Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2023, 02:59 AM
stepron.sjangam stepron.sjangam is offline Transfer data from userform to spacific cells range Windows 10 Transfer data from userform to spacific cells range Office 2021
Novice
Transfer data from userform to spacific cells range
 
Join Date: May 2023
Posts: 3
stepron.sjangam is on a distinguished road
Default Transfer data from userform to spacific cells range

I have created userform for the data entry & i need code to run this form in that spacific excel file.
I have attached excel & user form.
Need data entry in the "A" sheet.
Attached Files
File Type: xlsx 2nd Final.xlsx (39.5 KB, 6 views)
File Type: zip UserForm1.zip (723 Bytes, 6 views)
Reply With Quote
  #2  
Old 05-26-2023, 05:27 AM
stepron.sjangam stepron.sjangam is offline Transfer data from userform to spacific cells range Windows 10 Transfer data from userform to spacific cells range Office 2021
Novice
Transfer data from userform to spacific cells range
 
Join Date: May 2023
Posts: 3
stepron.sjangam is on a distinguished road
Default

Anyone here to help me with the VBA code.
Reply With Quote
  #3  
Old 06-01-2023, 02:31 AM
stepron.sjangam stepron.sjangam is offline Transfer data from userform to spacific cells range Windows 10 Transfer data from userform to spacific cells range Office 2021
Novice
Transfer data from userform to spacific cells range
 
Join Date: May 2023
Posts: 3
stepron.sjangam is on a distinguished road
Default

Hi?
.
..
Reply With Quote
  #4  
Old 06-07-2023, 04:57 PM
Guessed's Avatar
Guessed Guessed is offline Transfer data from userform to spacific cells range Windows 10 Transfer data from userform to spacific cells range Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,967
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know how to read the .frm file you attached so I have no idea as to the specifics of what that should look like.

Excel does have an automatic 'form' interface that might work for you if you didn't need a lot of customisation. See this video for an example of how you might make it work
https://www.youtube.com/watch?v=cNpFB8M1-dI

If you wanted a VBA Userform which is highly customisable but will take a long time to create then have a look at this video to get an understanding of what will be involved.
https://www.youtube.com/watch?v=P53T6oxgUVA
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer DocVariables from one template's userform to another template's userform mdr Word VBA 7 02-14-2022 10:28 PM
How can I transfer specific data from email to specific excel cells? Mauro Outlook 1 11-11-2019 09:17 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) slaycock Word VBA 0 02-18-2017 07:00 AM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Transfer data from userform to spacific cells range Sum Formula in the range with Numeric and NonNumeric data cells Spanec Excel 2 01-12-2012 09:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft